How To Modify, Delete Calculated Field In Excel PivotTable

In the previous article, I told you how to add a calculated field to an excel PivotTable. In this article, I will tell you how to modify and delete the added calculated field in an excel PivotTable.

1. How To Modify, and Delete Calculated Field In Excel PivotTable.

1. Click any cell in the excel PivotTable to select it.
2. Click the “PivotTable Analyze” tab on the Excel ribbon.
3. Click on “Fields, Items & Sets” in the “Calculations” group.
4. Select “Calculated Field” from the drop-down menu to open the Insert Calculated Field dialog window.
5. In the “Insert Calculated Field” dialog window, click the down arrow at the end of the Name text box.
6. Then you can select the existing calculated field from the Name drop-down list.
   
7. After you select the existing calculated field from the Name drop-down list, the Add button will be changed to Modify, and Delete beside it automatically.
8. You can change the calculated field formula as you need, and click the Modify button to save the changes.
9. If you change the field name, then the Modify button will be changed to Add, you can click the Add button to add a new calculated field.
10. You can click the Delete button to delete the calculated field.

References

1. How To Use Excel Formula To Add Calculated Field In PivotTable.