How to name a Group in a pivot table?

%3CLINGO-SUB%20id%3D%22lingo-sub-2643579%22%20slang%3D%22en-US%22%3EHow%20to%20name%20a%20Group%20in%20a%20pivot%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2643579%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20rename%20the%20Groups%20in%20a%20Pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20am%20facing%20difficulties.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20How%20do%20I%20rename%20Group3%20to%20%22East%20of%20England%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20How%20do%20I%20rename%20Group2%20to%20%22Tyneside%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20%3B%20)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2643579%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2643831%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20name%20a%20Group%20in%20a%20pivot%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2643831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1127434%22%20target%3D%22_blank%22%3E%40Edwin_Tan%3C%2FA%3E%26nbsp%3BI'd%20say%20you%20do%20a%20Find%20%26amp%3B%20Replace%20in%20the%20data%20source%2C%20where%20you%20probably%20have%20a%20%3CEM%3Eregion%3C%2FEM%3E%20column%20with%20data%20like%20%22Wearside%22%2C%20%22Group2%22%20and%20%22Group3%22.%20Then%20refresh%20the%20Pivot%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 Replies

@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.

@Riny_van_Eekelen 

 

Thanks, Riny.

 

I will give it a try.