{"id":256,"date":"2014-09-24T14:54:00","date_gmt":"2014-09-24T12:54:00","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=256"},"modified":"2024-06-05T17:14:16","modified_gmt":"2024-06-05T15:14:16","slug":"show-pivot-table-values-as-a-running-total-in","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-pivot-table-values-as-a-running-total-in\/","title":{"rendered":"Show Pivot Table Values As a Running Total In"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-pivot-table-values-as-a-running-total-in\/#Show_Pivot_Table_Values_As_a_Running_Total_In\" title=\"Show Pivot Table Values As a Running Total In\">Show Pivot Table Values As a Running Total In<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Show_Pivot_Table_Values_As_a_Running_Total_In\"><\/span>Show Pivot Table Values As a Running Total In<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to track your sales on a monthly basis and see their Year to Date totals, then you can easily do this with the <em>Running Totals In<\/em> calculation.<\/p>\n<p>You can activate this by <em>Right Clicking<\/em> on your <a class=\"wpil_keyword_link\" title=\"Pivot Table\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> values and choosing <em>Show Values As<\/em> and <em>Running Total In<\/em>.\u00a0 You can also activate this by going in to the<em> Value Field Setting<\/em> section, which is the method that I show below.<\/p>\n<p><span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/YTD.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">YTD.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>Here is our current Pivot Table setup, with the sum of sales being shown for each month-year combination.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23417\" title=\"Show Pivot Table Values As a Running Total In\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-01.jpg\" alt=\"Show Pivot Table Values As a Running Total In\" width=\"849\" height=\"473\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-01.jpg 849w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-01-300x167.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-01-768x428.jpg 768w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Click on <strong>Sum of Sales <\/strong>and select <strong>Value Field Settings<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23418\" title=\"Show Pivot Table Values As a Running Total In\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-02.jpg\" alt=\"Show Pivot Table Values As a Running Total In\" width=\"338\" height=\"506\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-02.jpg 338w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-02-200x300.jpg 200w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Select the following inside\u00a0<strong>Show Values As<\/strong>:<\/p>\n<p>Show values as:<strong> Running Total in<\/strong><\/p>\n<p>Base Field: <strong>MONTH<\/strong><\/p>\n<p>Click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23419\" title=\"Show Pivot Table Values As a Running Total In\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-03.jpg\" alt=\"Show Pivot Table Values As a Running Total In\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-03.jpg 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-03-300x257.jpg 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/p>\n<p>The values are now shown as <strong>running totals<\/strong> throughout the months!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23420\" title=\"Show Pivot Table Values As a Running Total In\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-04.jpg\" alt=\"Show Pivot Table Values As a Running Total In\" width=\"424\" height=\"219\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-04.jpg 424w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Show-Pivot-Table-Values-As-a-Running-Total-In-04-300x155.jpg 300w\" sizes=\"(max-width: 424px) 100vw, 424px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Show Pivot Table Values As a Running Total In If you want to track your sales on a monthly basis and see their Year to Date totals, then you can easily do this with the Running Totals In calculation. You can activate this by Right Clicking on your Pivot Table values and choosing Show Values [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17474,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Show Pivot Table Values As a Running Total In","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[18,4],"tags":[88,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/256"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=256"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/256\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17474"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}