question

68278686 avatar image
0 Votes"
68278686 asked VikiJi-MSFT commented

Excel Pivot Calculated Field : Inactive to Active

I try to use calculated field in pivot but it is not active in my excel tool. How is it possible to make it active ?

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VikiJi-MSFT avatar image
0 Votes"
VikiJi-MSFT answered VikiJi-MSFT commented

Hi @68278686,
Welcome to Q&A forum!

Which version of Office are you using? Please update it to the latest version first.

Does your data source come from OLAP?

  • If so, please note that "You cannot create formulas in a PivotTable that is connected to an Online Analytical Processing (OLAP) data source".

For more information: Calculate values in a PivotTable.

  • If not, please check to make sure that the Add this data to the Data Model option is not checked when creating the PivotTable.

132701-image.png

If none of the above conditions are met, please create a new file and create a new PivotTable and share the result with us.

Any updates, please let me know.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


image.png (16.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @68278686,
How is your issue going now? Please feel free to post back any updates.
Thanks~

0 Votes 0 ·