When you create a Pivot Table that has multiple fields in the Row Labels, Excel will automatically add a Subtotal to the top of the Group.
What about if you want to change the Subtotals to show at the bottom of the Group or take the Subtotals out all together?
Well you have that flexibility when you are dealing with Subtotals, here is how:
STEP 1: Enter at least two Fields in the Row Labels
STEP 2: Click in your Pivot Table and go to PivotTable Tools > Design > Subtotals
STEP 3: You can choose either of the three options:
