O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required