In a PivotTable, subtotals are calculated automatically and appear by default. Here’s how to hide them:
- Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
- Click Design > Subtotals, and then pick Do Not Show Subtotals.
In a PivotTable, subtotals are calculated automatically and appear by default. Here’s how to hide them: