Pivot table: header

[fmazzarelli]

Hi Community,

how to change the column heading in relation to a value ?

Example header
if 1 = Cost
if 2 = Revenue
if Total = 3

[robert_mika]

Do you want use variable to change the field in your table or just the heading?

how is the 1,2,3 defined?

[settu_periasamy]

Hi,

Try it in your calculated dimension..

Pick(Match(Field,'Cost','Revenue','Total'),'Cost','Revenue','Total')

[SreeniJD]

Try this..

Pick(Match(Dimension,'1','2','3'),'Cost','Revenue','Total')

Sreeni