How to enable Pivot Table What-If Analysis option


Can anyone tell me how to enable Pivot Table What-If analysis, located under PivotTable Analyze >> Options >> Data?


I have enabled the default setting, located under File >> Options >> Data >> Edit Default Layout >> Pivot table options >> Data.  I am using an external data source and have "load to data model" unchecked.


I also do not have Calculated Items available, located under PivotTable Analyze >> Fields, items & sets.  Calculated field is available, but not calculated item.


I am using Office 365 for Enterprise.





0 Replies