How to change field in dynamic dimension according to select field value?

[yanivvl0]

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 .

[marcus_sommer · Accepted solution]

Maybe with something like this:

pick(match(Status, 210,211,...), year_fld_1, year_fld_2, ...)

- Marcus

[yanivvl0]

thanks M arcus !!