How to name a Group in a pivot table?

Question

Hi everyone,&nbsp;I am trying to rename the Groups in a Pivot table.&nbsp;However, I am facing difficulties.&nbsp;&nbsp;&nbsp;1) How do I rename Group3 to "East of England"?&nbsp;2) How do I rename Group2 to "Tyneside"?&nbsp;Thank you very much ; )

riny_van_eekelen · Answer

Edwin_Tan&nbsp;I'd say you do a Find &amp; Replace in the data source, where you probably have a region column with data like "Wearside", "Group2" and "Group3". Then refresh the Pivot table.

edwin_tan1400 · Answer

Riny_van_Eekelen&nbsp;&nbsp;Thanks, Riny.&nbsp;I will give it a try.

Forum Discussion

How to name a Group in a pivot table?

2 Replies

Resources