Forum Discussion
Solved
Calculate filed is not activated for Pivot Tables.
My Excel version is updated to Excel 365, after the update the calculated field is not activated under the pivot options. Kindly expect a solution for this. Pls. refer to the attachment.
NishanpeCA Your PT is created via the Data Model. Then you need DAX measures or calculated columns. Create your PT outside the DM if you want to use the Calculated Fields option in the ribbon.
See attahed.
3 Replies
NishanpeCA Your PT is created via the Data Model. Then you need DAX measures or calculated columns. Create your PT outside the DM if you want to use the Calculated Fields option in the ribbon.
See attahed.
Thanks lot. I was checking the error for the last two months.
