Download Excel Workbook
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:
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.
