Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I would like to ask you if there is a way to have in a pivot table the same measure but with different column label according to the a different value of a dimension.
For instance I have a list of KPIs as a dimension in columns and I have a measure called FCST (meaning Forecast value), I would like to renamen the label 'FCST' in a different way only for a specific KPI. Is that possible?
The if confition or pick(match()) do not work. I also tried to add a new column for that KPI but the if condition to hide the column for the other KPIs do not work either in the "Calculation condition" statement.
Do you have any idea about it could be done?
thanks a lot!
As far as I know, this isn't possible.