Add Subtotals In Pivottable. 2 specify the calculation type from the Use function drop-down list. To show pivot table custom subtotals for the inner or outer pivot fields follow these steps.
Hide or Show One Subtotal. This example sets the field that contains the active cell to show Sum subtotals. The invoked drop-down menu allows you to display the subtotals at the top or bottom of each item in the outer row fields in compact or outline form or hide subtotals.
If you forget to uncheck this box your new subtotals will show up and all your previous subtotals will disappear.
This example sets the field that contains the active cell to show Sum subtotals. People also ask how do you add subtotals in a pivot table. To show pivot table custom subtotals for the inner or outer pivot fields follow these steps. Right-click one of the Region row labels and click Field Settings.
