different labels for the same measure (pivot table)
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.