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.
I remove the unwanted subtotals by right clicking on one of the totals and selecting “Hide”.
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).
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.
This enables you to add and remove subtotals at will.