Remove subtotals from a pivottable

In a PivotTable, subtotals are calculated automatically and appear by default. Here's how to hide them:

1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

   

2. Click Design > Subtotals, and then pick Do Not Show Subtotals.

More about PivotTables

• Create a PivotTable to analyze worksheet data

• Create a PivotTable to analyze external data

• Create a PivotTable to analyze data in multiple tables

• Show or hide subtotals and totals in a PivotTable

• Calculate a percentage for subtotals in a PivotTable

• Sum values in a PivotTable