{"id":1494,"date":"2020-10-25T21:00:32","date_gmt":"2020-10-25T15:30:32","guid":{"rendered":"https:\/\/www.complianceprime.com\/blog\/?p=1494"},"modified":"2024-03-23T16:01:30","modified_gmt":"2024-03-23T10:31:30","slug":"how-to-change-the-pivot-table-calculations-in-excel","status":"publish","type":"post","link":"https:\/\/www.complianceprime.com\/blog\/2020\/10\/25\/how-to-change-the-pivot-table-calculations-in-excel\/","title":{"rendered":"How to Change the Pivot Table Calculations in Excel"},"content":{"rendered":"

Pivot tables in Excel are a great way to compile a large number of data without complicated formulas. But if you want to, you can create formulas in a pivot table, with calculated items and calculated fields. After you create the table, here is how you can change pivot table calculations in Excel.<\/span><\/p>\n

Related Webinars<\/div>
\"Speaker\"
Advanced Excel Functions: Lookup and Logical Tools<\/div>
<\/div>
<\/div>
Speaker: <\/strong>Neil Malek<\/div>
Learn More<\/div><\/div>
\"Speaker\"
Microsoft Office Productivity Toolkit: Working Smarter with Microsoft Excel, Outlook, & OneNote<\/div>
<\/div>
<\/div>
Speaker: <\/strong>Mike Thomas,Neil Malek<\/div>
Learn More<\/div><\/div>
\"Speaker\"
Turn Outlook into a Project Management Tool with OneNote Integration<\/div>
<\/div>
<\/div>
Speaker: <\/strong>Neil Malek<\/div>
Learn More<\/div><\/div><\/div><\/div><\/span><\/p>\n

Pivot Table Calculations<\/span><\/h2>\n

If you are unsure about the type of formula to use, view the demonstration of pivot table calculated items and calculated fields. Here is the chief difference between the two:<\/span><\/p>\n

    \n
  • Calculated Fields are methods that can refer to different fields in the pivot table in Excel.<\/span><\/li>\n
  • Calculated Items are methods that can refer to different items in a particular pivot field in Excel.<\/span><\/li>\n<\/ul>\n

    Change the Calculated Field Formula<\/span><\/h2>\n

    After creating a calculated field, if necessary, you can change or modify the formula later. These are the steps to change the calculated field formula:<\/span><\/p>\n

      \n
    • In the pivot table, choose a cell, and on the Excel Ribbon, click the Analyze tab.<\/span><\/li>\n
    • And, in the Calculations group, click on the Fields, Items, and Sets, and after that click on the Calculated Field.<\/span><\/li>\n
    • Click the arrow on the Name box, and choose the calculated field that needs to be changed.<\/span><\/li>\n
    • In the Formula box, you can change the formula.\u00a0<\/span><\/li>\n
    • Click on the Modify button to save the calculated field modifications.<\/span><\/li>\n
    • After that click on Close.<\/span><\/li>\n<\/ul>\n

      Conclusion<\/span><\/h2>\n

      Hope the article about “How to Change the PivotTable calculations in Excel” is explanatory. Attend the Compliance Prime webinar to learn more about the Pivot table calculations in excel.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      Pivot tables in Excel are a great way to compile a large number of data without complicated formulas. But if you want to, you can create formulas in a pivot…<\/p>\n","protected":false},"author":4,"featured_media":1495,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[6],"tags":[98],"class_list":["post-1494","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","tag-microsoft-excel"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/posts\/1494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/comments?post=1494"}],"version-history":[{"count":1,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/posts\/1494\/revisions"}],"predecessor-version":[{"id":5054,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/posts\/1494\/revisions\/5054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/media\/1495"}],"wp:attachment":[{"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/media?parent=1494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/categories?post=1494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.complianceprime.com\/blog\/wp-json\/wp\/v2\/tags?post=1494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}