Microsoft® Office Excel 2003 Inside Out

Using Grand Totals and Subtotals

By default, Excel generates grand totals for all outer fields in your table and subtotals for all inner fields except the innermost. You can suppress the default totals and also generate subtotals for the innermost fields.

Grand Totals

If you use more than one data field, the PivotTable And PivotChart Wizard generates separate grand totals for each data field. A grand total always uses the same summary function as the data field it totals. For example, if your PivotTable uses the Sum function, its grand totals are grand sums. If you use Average instead of Sum, you get grand averages, and so on.

Change summary functions

To switch from one summary function to another, select an item in the data area of your PivotTable, ...