Pinterest Pixel

Editing a Calculated Field

Calculated Fields in Excel Pivot Tables are very flexible to use. However, sometimes making modifications to them... read more

Download Excel Workbook
Bryan
Posted on

Overview

Editing a Calculated Field | MyExcelOnline

Calculated Fields in Excel Pivot Tables are very flexible to use. However, sometimes making modifications to them is not that straightforward as the interface is not that intuitive.

Let me show it to you so that you can master editing a calculated field in a few steps!

 

Don’t forget to download the Exercise Workbook below and follow along with us:

download excel workbookEditing-a-Calculated-Field.xlsx


This is our current Pivot Table setup:

Editing a Calculated Field

STEP 1: Select anywhere on your Pivot Table. Go to PivotTable Analyze > Fields, Items, & Sets > Calculated Field

Editing a Calculated Field

STEP 2: Click on the dropdown list so that you can see all of the existing Calculated Fields

Editing a Calculated Field

STEP 3: Select COGS and now you will see two buttons: Modify and Delete

If you want to make changes to the Formula, select Modify. If you want to remove it, then select Delete

Let us try out deleting this, click Delete

See also  Filter by Values - Top or Bottom Sum

Editing a Calculated Field

Click OK

Editing a Calculated Field

Now you have your updated Pivot Table!

Editing a Calculated Field

By following these steps, you can easily edit or delete a calculated field in Pivot Table!

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Editing a Calculated Field | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!