Calculate filed is not activated for Pivot Tables.

New Contributor

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.

3 Replies
best response confirmed by Peter Bartholomew (Trusted Contributor)

@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.


Just in case, you may check/change your default settings here