Question

How to remove calculated field in pivot table

Answer 1

To remove a calculated field in a pivot table, select any cell within the pivot table, go to the PivotTable Analyze tab, and select Fields, Items, & Sets followed by Calculated Field. In the dialog, select the field you want to delete and click the Delete button.

Step-by-step explanation:

To remove a calculated field in a pivot table, you will need to follow these steps:

1. Select any cell within the pivot table that contains the calculated field you want to remove.
2. Go to the PivotTable Analyze tab on the Excel ribbon (this might be called Options or PivotTable Tools, depending on your version of Excel).
3. Click on Fields, Items, & Sets and choose Calculated Field from the dropdown menu.
4. In the Calculated Field dialog, you will see a list of all calculated fields in your pivot table.
5. Select the calculated field you wish to remove from the list.
6. Click the Delete button.
7. Click Ok to close the dialog box.

After these steps, the calculated field will no longer appear in your pivot table. If you wish to add it back, you will need to recreate the calculated field again.