Remove Calculated Field From Excel Pivot Table

After you create a calculated field in an Excel pivot table, you might want to remove it from the pivot table layout. You can temporarily remove a calculated field, or you can permanently remove it.

In this example, the pivot table has a calculated field named Bonus. It appears in the Values area as Sum of Bonus. You could hide the Bonus calculated field, or delete it from the pivot table.

PivotCalcField01

Temporarily Remove a Calculated Field

To temporarily remove a calculated field from a pivot table, follow these steps:

  1. In the pivot table, right-click a cell in the calculated field. In this example, we’ll right-click the Bonus field.
  2. In the popup menu, click the Remove command that shows the name of the calculated field.

PivotCalcField02

The calculated field is removed from the pivot table layout, but remains in the PivotTable Field List.

Later, you can add a check mark to the calculated field in the PivotTable Field List, to return it to the pivot table layout.

Permanently Remove a Calculated Field

To permanently remove a calculated field, follow these steps:

  1. Select any cell in the pivot table.
  2. On the Ribbon, under the PivotTable Tools tab,  click the Options tab.
  3. In the Tools group, click Formulas, and then click Calculated Field.
  4. From the Name drop down list, select the name of the calculated field you want to delete.
    • PivotCalcField03
  5. Click Delete, and then click OK to close the dialog box.

______________

For more information on Pivot Tables, please see the Pivot Table Tutorials on the Contextures Website.

______________

7 thoughts on “Remove Calculated Field From Excel Pivot Table”

  1. Hello_
    Based on your explanation of calculated fields, can I state:
    1)A calculated field is any cell formula “outside” the PV Table that uses the PV Table’s results?
    or
    2)Any Total or subtotal of the PV Table?
    Thank you
    Joseph

  2. Ditto Lee Mei Ling. Cannot execute these instructions because the tools are disabled while the pivot table is selected.

  3. What is an OLAP based pivot table? Therefore it is not possible to remove a calculated field at all when it is OLAP based?

Leave a Reply to Ben Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.