Share via

Excel Pivot Calculated Field : Inactive to Active

민수 기 1 Reputation point
2021-09-16T03:47:14.957+00:00

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 ?

Microsoft 365 and Office Excel For business Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viki Ji_MSFT 4,471 Reputation points
    2021-09-16T08:56:41.497+00:00

    Hi @민수 기 ,
    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.