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.