Share via

How can I delete a calculated field in a pivot table?

Anonymous
2012-10-22T20:27:35+00:00

Original Title: Pivot Table Problem

I created a new calculated field in a pivot table, now I want to erase that calculated field. How does one erase a caculated field?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2012-10-22T20:36:20+00:00

    Click anywhere in the pivot table.

    Activate the Options tab of the ribbon, under PivotTable tools.

    Click Calculations > Fields, Items & Sets > Calculated Field...

    Select your calculated field from the Name dropdown.

    Click Delete.

    2 people found this answer helpful.
    0 comments No comments