When you add field to the Row or Column area of a pivot table, subtotals automatically appear in the outer fields. If you want to turn off some of the subtotals, keep reading!
Pivot Table Subtotals
For example, in the following pivot table, Region and Employee are the outer fields, and show subtotals.
In the next section, see how you can turn off pivot table subtotals for some fields.
Remove Subtotals in Excel 2007
In Excel 2007 you can turn off all subtotals for the active pivot table, and prevent new subtotals from appearing:
- Select a cell in the pivot table
- On the Ribbon, click the Design tab
- In the Layout group, click Subtotals, and click Do Not Show Subtotals.
However, there’s no setting you can change to make this the default behaviour for all pivot tables.
Remove Subtotals in Excel 2003
In earlier versions of Excel, you have to turn off the subtotal for each field individually, either manually or programmatically.
To manually turn off a field’s subtotals:
- Double-click the field button, to open the PivotTable Field dialog box.
- Under Subtotals, click None, then click OK.
More Subtotal Info
For more tips, examples, and videos, go to the Pivot Table Subtotals page on my Contextures site.
______________
You’re only partially correct on the subtotal. Any new field dragged into the pivot is automatically subtotaled. Which means you have to turn it off again. Which is a pain on a slow data connection with 50000+ records.
Mary, which version of Excel are you using? The setting should stick in Excel 2007, but every field has to be set individually in Excel 2003.
May thanks for the add-in – my RSI thanks you enormously!
So is there a way to switch of subtotals per data group rather than for the whole table, i have one group, group total so end ups with group, subtotal, group, subtotal, total when all i want is group, sub, total.
Thank you for solution it works on every tabs if selection is done while the cursor on values fields.
Very impressive instructions! Clear, simple and concise. Thanks!
VERY HELPFULL