Excel Guides

Removing Subtotals from Many PivotTable Fields in Excel

If you have a PivotTable with multiple fields, you may want to remove the subtotals from some or all of the fields. This can be done by selecting the field(s) in the PivotTable, and then clicking the "Remove Subtotals" button on the "Design" tab of the PivotTable toolbar.

When you remove subtotals from a PivotTable field, all of the data in that field is shown in one flat list, without any subtotals or grand totals. This can be useful if you want to see all of the data in a field, without any summarization.

You can remove subtotals from multiple fields at the same time by selecting them all before clicking the "Remove Subtotals" button. Or, you can remove subtotals from all fields in the PivotTable by clicking the "Remove All Subtotals" button.

If you later decide that you want to add back subtotals to a field (or fields), you can do so by selecting the field(s) and then clicking the "Add Subtotals" button on the "Design" tab of the PivotTable toolbar.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.