Excel PivotTable Subtotal Label Trick

I just learned a new trick for labelling subtotal rows in a PivotTable. Hat tip to Ken Puls MVP of Excel Guru for this tip.

The standard subtotal rows in a PivotTable might look something like this.

There is nothing wrong with this terminology but if you wanted to change the text on the subtotal rows you can do something like what is shown in the image below.

And when you press Enter the whole table updates with the new subtotal terminology – see image below.

The secret is that you need to use the same text as the row label. In the above case I need to use the word Government in my changed terminology.

If I use Gov’t it doesn’t work – see image below.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.