PDA

View Full Version : PIVOT table - Change sub column label



Sarfaraz
03-06-2013, 10:58 PM
I have a pivot table its column label is product their are four prodcuts being reflected by numbers at sub level. I want to replace these number by the product name only in pivot without changing my origional data. Can someone help me that how can I change this.

Product400003400400003402400003404400003405

I would like to change the number 400003400 wtih A and so on
Thanks

Bob Phillips
03-07-2013, 03:11 AM
Post your workbook and tell us what needs changing and to what.

Sarfaraz
03-07-2013, 03:49 AM
Attached please find the file Would like to change in the Pivot

400003402 as toffees
400003404 as cakes

Bob Phillips
03-07-2013, 04:04 AM
Where do you propose to get the text from?

Sarfaraz
03-07-2013, 11:27 PM
I would like to change this manually in the PIVOT table like I can change other field headings in pivot.