What-if analysis with Pivot Table

[uni88]

Hi all,

I have a dataset on sheet 1 and on sheet 2 i created a pivot table and i want to perform what-if analysis on the pivot table data.

The problem is that the What-If analysis doesn't appear under the analyze tab and i cant select it from the Pivottable option (Data tab)--> Enable cell editing in the values area option is not available.

Any Solutions??!!!...

Thanks in advance