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 ?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Viki Ji_MSFT 4,441 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.