Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
how to change the column heading in relation to a value ?
Example header
if 1 = Cost
if 2 = Revenue
if Total = 3
Do you want use variable to change the field in your table or just the heading?
how is the 1,2,3 defined?
Hi,
Try it in your calculated dimension..
Pick(Match(Field,'Cost','Revenue','Total'),'Cost','Revenue','Total')
Try this..
Pick(Match(Dimension,'1','2','3'),'Cost','Revenue','Total')
Sreeni