Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
235
Views
Topic starter
Hi there
went to utilise this tutorial
https://www.myonlinetraininghub.com/excel-pivottable-calculated-items-by-position
however I stumble at the first point where it says: PivotTable Analyze tab (Excel 2013) > Fields, Items & Sets > Calculated Item.
My option is greyed out, along with Calculated Field, Solve Order and List Formulas.
Im using PowerPivot and pulling data from PowerQuery.
Thanks for any help in explaining why the option is greyed out.
all the best,
- Mike
Posted : 13/01/2018 3:46 pm
Hi Mike,
Here is a detailed article that explains the differences: differences-between-olap-and-non-olap-pivottables-in-excel
Calculated Fields and Calculated Items
You cannot create a calculated field or a calculated item in a PivotTable based on OLAP source data.
Posted : 14/01/2018 3:09 am
