How to name a Group in a pivot table?

[Edwin_Tan]

Hi everyone,

I am trying to rename the Groups in a Pivot table.

However, I am facing difficulties.

1) How do I rename Group3 to "East of England"?

2) How do I rename Group2 to "Tyneside"?

Thank you very much ; )

[#2]

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

[#3]

@Riny_van_Eekelen 

Thanks, Riny.

I will give it a try.