Editing a Calculated Field

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:

This is our current Pivot Table setup:

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

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

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

Click OK

Now you have your updated Pivot Table!

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:

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.