Calculated fields appear in the PivotTable Field List window. Calculated items appear as items within other fields.
Delete a calculated field- Click the report.
- On the PivotTable toolbar, click PivotTable or PivotChart, point to Formulas, and then click Calculated Field.
- In the Name box, click the field you want to delete.
- Click Delete.
- Click the field with the item you want to delete.
- On the PivotTable toolbar, click PivotTable or PivotChart, point to Formulas, and then click Calculated Item.
- In the Name box, click the item you want to delete.
- Click Delete.
Note When you delete a formula from a PivotChart report or its associated PivotTable report, some chart formatting may be lost.
If you don't want to delete a formula permanently, you can hide the field or item. To hide a field, drag it out of the report, or click the dropdown arrow in the Data field and then clear its check box; it remains available in the field list. To hide an item, click the dropdown arrow in its field, and then clear the check box for the item.