Create a What if Analysis with only variables

[#1]

Hi Community,

I have a kind of unique request. I would like to make a basic what if analysis using only variables. I have no data loaded and only variables defined with sliders with min, max and step size values. I would like to create charts that compare the values calculated by two sets of sliders. Basically it would have 2 dimensions item 1 and item 2 with expressions one calculated with one set of sliders and the other with the other set. Basically dimension 1 values would be slider 1 *slider 2 and dimension 2 would be slider 3 * slider 4.

Is there a way to do this and if so how?

Thanks!

[sunny_talwar]

Do you have two dimensions or 1 dimensions with two fields in it (Item1 and Item 2)?

[#3]

Sorry one dimension with 2 fields

[#4]

I want the expression value for each field to be different and be a result of selected values of sliders.

[sunny_talwar · Accepted solution]

Like this?

Expression: =If(Dimension = 'Item1', vVar1 * vVar2, vVar3*vVar4)