Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
My data have a column called Activity, the values are Merchandising, Sales, Marketing.
Now I create a pivot table with Activity as pivot table columns:
I want to rename the values as MKT, Merch, Sales. What should I do?
Thanks in advance!
May be this as dimension instead of Activity, not tested though -
Aggr(Pick(Match(Activity,'Marketing','Merchandizing','Sales'),'MKT','Merch','Sales'),Activity)
May be this as dimension instead of Activity, not tested though -
Aggr(Pick(Match(Activity,'Marketing','Merchandizing','Sales'),'MKT','Merch','Sales'),Activity)
Can you rename them in your load script? If want those values to be permanent that is what I would do. Then you don't have to try to change them on every chart that you use them on.