Hello Experts,
I am designing a story based on a measure planning model in SAC; and need to display a 3 columns table with data from different years :
Actual data from YEAR=N-2 ; Budget data from YEAR=N-1 and Budget data from YEAR=N.
I want to do it based on the value a user enters in a prompt (based on a model YEAR variable) or in an input control.
Therefore, my question is if there is any way to apply an offset ("-1" and "-2") on the year value that the user enter in the prompt or the input control , and use those values then in restricted or calculated measure?
Do you have any idea how could I achieve that?
Thank you in advance,
Mickael