Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi to all , i have a chart , in it there is a year dimension ( and an expression ) , in the model there is another status field , and 4 year fields,
i need in the (calculate) year dimension - for every single selected value in the status field to use a different year field ,
for example : if i select status = 210 , then the dimension need to be year_fld_1 ,
if i select status = 211 , then the dimension need to be year_fld_2 ....
is there any way to do so ? THANKS .
Maybe with something like this:
pick(match(Status, 210,211,...), year_fld_1, year_fld_2, ...)
- Marcus
Maybe with something like this:
pick(match(Status, 210,211,...), year_fld_1, year_fld_2, ...)
- Marcus
thanks M arcus !!