Forum Discussion
Dynamic measure header in matrix
Hello,
I'm currently working with a matrix and I would like the header label for the measure "_BUD FY" to change based on the month number.
In this matrix data comes from "DB" table, no calendar involved.
The logic is as follows:
if the month number falls between 1 and 4, the label should be "BUD FY".
If the month number falls between 5 and 8, the label should be "YEE4".
Otherwise, if the month number is any other value, the label should be "YEE9".
Please note that there are no columns in the matrix, and I would like to keep the current format of the matrix as it is.
3 Replies
iLoveTea , You will not be able to change the measure name. Better to create a new column and use that in column of the matrix visual
Hello amitchandak
in my case, adding a calculated column in the column field well will not work because it will change the format of the matrix.
Hello, My problem is still not resolved.
amitchandak
