Excel pivot table add subtotal to grandtotal
In the screen shot below, the Tax column is a calculated field, and its subtotals are blank. If you have calculated fields in your pivot table, they will not show any custom subtotals. Problem With Calculated Field Custom Subtotals
That creates a blank line after the West region, which makes it easier to see where the inner field subtotals begin. On the Layout & Print tab, a check mark has been added to “Insert blank line after each item label” In the next screen shot, the Field Settings for the Region field are being changed.
You can also format the outer field to have a blank row after each item. To avoid confusing people who are using your pivot table, add a note on the worksheet, to explain that the city subtotals are at the end of the pivot table. City is the inner field, and the counts for the cities are just above the grand total. The following screen shot shows an example. However, it is important to understand that when you add custom subtotals for the inner fields, they appear below the last outer field, just above the grand total. To create subtotals for the inner fields, you create custom subtotals, following the steps above. You can’t change the order of the custom subtotals – they’ll appear in the same order as in the list of functions. When you add custom subtotals for the outer fields, they appear below the pivot field items, even if you have selected the option to “Display All Subtotals at Top of Group.” See the Custom Subtotals for Outer Fields