DIMENSION NAME

[oseimuduame]

Good Evening,

its been long time i was here, was on vacation and glad to be back here.

please is it possible i have a different name on each of my Heading in pivot table as shown below.

instead of having 0, 5, 11 i want to have a name for each number.

Any Help please

[sunny_talwar]

Type is a dimension, right? I think it should be possible, is it not working?

[Anonymous]

I guess, the Store_Name should be used as dimension, not Type.

(If I understood the question right...)

[vishsaggi]

May be using Pick() match() in calculated dimension like:

= Pick(Match(Types, 0, 5, 11), 'Yourname for 0', 'YourNameFor 5', 'YourNameFor 11')