• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Analyzing Data with PivotTab... > Using Grand Totals and Subtotals

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint