{"id":24598,"date":"2021-11-03T12:15:18","date_gmt":"2021-11-03T11:15:18","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24598"},"modified":"2024-02-06T16:01:50","modified_gmt":"2024-02-06T15:01:50","slug":"editing-a-calculated-field","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/editing-a-calculated-field\/","title":{"rendered":"Editing a Calculated Field"},"content":{"rendered":"

\"New<\/a><\/p>\n

Calculated Fields in Excel Pivot Tables <\/a><\/strong>are very flexible to use. However, sometimes making modifications to them is not that straightforward as the interface is not that intuitive.<\/p>\n

Let me show it to you so that you can master editing a calculated field in a few steps!<\/p>\n

 <\/p>\n

Don’t forget to download the Exercise Workbook<\/strong> below and follow along with us:<\/p>\n

\n

download excel workbook<\/strong><\/i><\/span>Editing-a-Calculated-Field.xlsx<\/span><\/a><\/p>\n

\n<\/div>\n

\n

This is our current Pivot Table<\/a> setup:<\/p>\n

\"Editing<\/p>\n

STEP 1:<\/strong><\/span> Select anywhere on your Pivot Table. Go to\u00a0PivotTable Analyze > Fields, Items, & Sets > Calculated Field<\/strong><\/em><\/p>\n

\"Editing<\/p>\n

STEP 2:<\/strong><\/span> Click on the dropdown list so that you can see all of the existing Calculated Fields<\/a><\/p>\n

\"Editing<\/p>\n

STEP 3:<\/strong><\/span> Select\u00a0COGS<\/strong> and now you will see two buttons: Modify<\/strong> and Delete<\/strong><\/p>\n

If you want to make changes to the Formula<\/a>, select\u00a0Modify<\/strong>. If you want to remove it, then select\u00a0Delete<\/strong><\/p>\n

Let us try out deleting this, click\u00a0Delete<\/strong><\/p>\n

\"Editing<\/p>\n

Click\u00a0OK<\/strong><\/p>\n

\"Editing<\/p>\n

Now you have your updated Pivot Table!<\/p>\n

\"Editing<\/p>\n

By following these steps, you can easily edit or delete a calculated field in Pivot Table!<\/p>\n

 <\/p>\n

Make sure to download our FREE PDF on the\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":2,"featured_media":25132,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Editing a Calculated Field","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4],"tags":[800,799,798],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24598"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=24598"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24598\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25132"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}