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

Chapter 3. Customizing Fields in a Pivot Table > Adding and Removing Subtotals

Adding and Removing Subtotals

Subtotals are undeniably an essential feature of pivot table reporting. There are times when you will want to suppress the display of subtotals and other times when you will want to show more than one subtotal per field.

Suppress Subtotals When You Have Many Row Fields

When you have many row fields in your report, subtotals can mire your view. Take the example in Figure 3.9.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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