Sub Totals and Pivot Table Reports

Removing sub totals from pivot table reports

When you add detail to pivot table rows, Excel will automatically add a subtotal row. This can very quickly litter your pivot table with unnecessary detail.

Pivot table littered with subtotals

I remove the unwanted subtotals by right clicking on one of the totals and selecting “Hide”.

Removing subtotals from pivot table

Removing subtotals from pivot table

Adding sub totals to pivot table reports

Having removed all my unwanted subtotals, I will typically decide to rearrange the ordering in my pivot table and find I am missing a vital subtotal. It is possible to reapply subtotaling though – so don’t panic.

Following on from the examples above, it may be preferable to have the Cost Centre description appearing first rather than the cost centre code (which means nothing to anyone outside of finance).

Inserting subtotals in pivot tables

To add the subtotal against this description, right click in any of the description values, choose “Field Settings” and then make sure the radio¬†box labeled “Automatic” is selected.

Inserting subtotals in pivot tables

Inserting subtotals in pivot tables

This enables you to add and remove subtotals at will.

Inserting subtotals in pivot tables

Share the Love
Get Blog Updates

Excel Tutorial

  • Bhargav

    Thank you so much for sharing the tips.

Excel Tutorial