Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I would like create what if analysis , like select a buyer increase or decrease its projections. Please kindly refer the below and advise
E.g Buyer A increase its projection by 250
Buyer c decrease its projection by 50
COMPANY | QUARTER | BUYER | Actual | Confirmed | Projection | 2014 | 2013 | Variance with Last Year | Budget | Variance with Budget |
EMJAY | Qtr1 | A | 100 | 0 | 100 | 200 | 150 | 50 | 80 | 120 |
EMJAY | Qtr1 | B | 0 | 0 | 0 | 0 | 50 | -50 | 70 | -70 |
EMJAY | Qtr1 | C | 100 | 0 | 100 | 200 | 50 | 150 | 90 | 110 |
Thank You
BR
Jayanthan
have you tried input fields?
There are objects like Sliders that are really useful for these analysis, right click -> new sheet object -> sliders / calendar
Create two variables that can be manipulated with a slider.
In a pivot table create an expression something like this:
If(Buyer='A', Projection*VariableforBuyerA, if(Buyer='B', Projection*VariableforBuyerB))
Br
Cris