Oct 31 2021 07:16 AM
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.
Oct 31 2021 07:26 AM - edited Oct 31 2021 08:06 AM
Solution@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.
Oct 31 2021 07:58 AM
Thanks lot. I was checking the error for the last two months.
Oct 31 2021 09:43 AM
Oct 31 2021 07:26 AM - edited Oct 31 2021 08:06 AM
Solution@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.