what if analysis

[#1]

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

[hectorgarcia]

have you tried input fields?

[alexandros17]

There are objects like Sliders that are really useful for these analysis, right click -> new sheet object -> sliders / calendar

[mr_novice]

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