## 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.

### 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.

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.
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.

______________

### 6 comments to Remove Calculated Field From Excel Pivot Table

• Joseph Lisboa

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

• Joseph, a calculated field is created within a pivot table, by using the Formulas command on the Ribbon’s Option tab, while a pivot table cell is selected.

There are instructions on the Contextures website for creating a calculated field in a pivot table.

• Lee Mei Ling

May i Know why my pivot formula field is disable???

• Dru Sangemino

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

• If your pivot table is OLAP based, the calculated field feature won’t be available.

• Ben

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