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.