Delete Calculated Field in the Pivot Table

Remove the calculated field from a pivot table.

  1. Click any cell inside the pivot table.
  2. Go to Analyze >> Calculations >> Fields, Items & Sets >> Calculated Field….
  3. Select the field name you want to remove and click Delete.
  1. Click OK. Now, your Pivot Table doesn’t have Fields: Field1 and Field2.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.