I want to add four expression in one variable

[mithunr40]

Hello,

I want to add four expression in one variable after that i want to show that variable in dropdown list after that i will select any one expression from that dropdown list and then in one sheet many reports are there and it should changes the values of pivot table  as per the selection of the expression. 

Is there any solution.

Thank you so much.

[Mark_Little]

HI @mithunr40 

I use this all the time, but using to two variables Something like

vInput and vExpression.

vInput will but linked to your drop down and set the variable between 1 - 4.

The vExpression hold your four expressions and used in the chart. 

IF (vInput = 1,SUM(1), IF(vInput = 2, SUM(2)..

So on

[mithunr40]

Hello Mark,

Can you please elaborate of vInput expression i didnt understand.

Just show me how you using exactly for two variables.

Thanks.