Hoping someone could help me to resolve a situation with dynamic calculations on SAP Analytics Cloud.
Basically , I have 3 Cross Calculations. The first 2 are restrictions on the individual measures but the 3rd one should be a calculation of Cross Calculation 1 * [User Input]. To cater for the user input, I have create a variable on the model but this variable cannot be directly referenced in the cross calculations, or even story calculations.
I have tried to created a measure in the model that references the variable but that also cannot be referenced in a cross calculation.
I can do static calculations like Cross Calculation 1 * 10 but cannot find a way to do this dynamically ,where I can change 10 to 20 etc..
The user input should reflect on each row.
Do you know of anyway to reference the value from the variable prompt directly in a cross calculation or an alternative way to do this?
Thank you so much for taking some time to look at this post.