SAP Analytics Cloud: Use Variable Value in Cross Calculations

Hello

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.

Best Regards