{"id":3020,"date":"2021-03-20T14:58:22","date_gmt":"2021-03-20T13:58:22","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3020"},"modified":"2024-03-22T18:43:16","modified_gmt":"2024-03-22T17:43:16","slug":"show-difference-previous-years-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-difference-previous-years-excel-pivot-tables\/","title":{"rendered":"Show The Difference From Previous Years With Excel Pivot Tables"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\"><strong>Excel Pivot Tables<\/strong><\/a> have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the<strong> Calculate Difference between Two Pivot Tables<\/strong> option.<\/p>\n<p>You can<strong> show the values as the <em>Difference From<\/em><\/strong> previous months, years, day, etc. \u00a0This is just great when your boss asks you how you are tracking to the previous <em>months, years, days.<\/em><\/p>\n<p>In this tutorial you will learn how to show:<\/p>\n<div class=\"contents\">\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#calculate-difference-between-two-columns\"><strong>Calculate Difference between Two Columns<\/strong><\/a><\/li>\n<li><a href=\"#calculate-%-difference-between-two-columns\"><strong>Calculate % Difference between Two Columns<\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<p>Let&#8217;s look at both of these methods one-by-one!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"calculate-difference-between-two-columns\"><\/a>Calculate Difference Between Two Columns<\/span><\/h3>\n<p>You can use the Pivot Table difference between columns function to <strong>calculate Year on Year variance in absolute values<\/strong>. Below is the data that you will be using:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-295.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23080\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-295.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"1194\" height=\"453\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-295.png 1194w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-295-300x114.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-295-1024x389.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-295-768x291.png 768w\" sizes=\"(max-width: 1194px) 100vw, 1194px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n\n<h4>Follow the<strong>\u00a0step-by-step tutorial<\/strong> on How to <strong>Calculate Difference between Two Pivot Tables<\/strong> and <strong>download this Excel workbook<\/strong>\u00a0to practice along:<\/h4>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Difference-From-Previous-Year.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Difference-From-Previous-Year.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Difference-From-Previous-Year.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Insert a Pivot Table by clicking on your data and going to<em><strong> Insert &gt; Pivot Table\u00a0<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23081\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"944\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296.png 944w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296-300x40.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296-768x103.png 768w\" sizes=\"(max-width: 944px) 100vw, 944px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong><\/em>In the Create PivotTable dialog box, Select <strong>Table range<\/strong> and then click on <strong>New Worksheet<\/strong>. Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivot.png\" rel=\"attachment wp-att-2643\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2643\" title=\"Show The Difference From Previous Months With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivot.png\" alt=\"Show The Difference From Previous Months With Excel Pivot Tables\" width=\"387\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivot.png 387w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivot-300x253.png 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> In the <strong>ROWS<\/strong>\u00a0you have to put the <em>Months<\/em> field, in the <strong>COLUMNS<\/strong>\u00a0the <em>Years<\/em> field and in the <strong>VALUES\u00a0<\/strong>area the <em>Sales<\/em> field twice, I explain why below:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivottable-fields.png\" rel=\"attachment wp-att-2644\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2644\" title=\"Show The Difference From Previous Months With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivottable-fields.png\" alt=\"Show The Difference From Previous Months With Excel Pivot Tables\" width=\"337\" height=\"568\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivottable-fields.png 337w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivottable-fields-178x300.png 178w\" sizes=\"(max-width: 337px) 100vw, 337px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Now click on the second Sales field&#8217;s <em>(Sum of SALES2<\/em>) drop down and choose<strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-field-and-value-settings-in-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Value Field Settings<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/value-field-settings.png\" rel=\"attachment wp-att-2645\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2645\" title=\"Show The Difference From Previous Months With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/value-field-settings.png\" alt=\"Show The Difference From Previous Months With Excel Pivot Tables\" width=\"363\" height=\"325\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/value-field-settings.png 363w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/value-field-settings-300x269.png 300w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span> <\/strong>Now you need to select the <strong>Show Values As<\/strong> tab and from the drop-down choose the <strong><em>Difference From<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/difference-from.png\" rel=\"attachment wp-att-2646\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2646\" title=\"Show The Difference From Previous Months With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/difference-from.png\" alt=\"Show The Difference From Previous Months With Excel Pivot Tables\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/difference-from.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/difference-from-300x257.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong> <\/span>You need to select the<strong> Base Item: (previous)<\/strong> and <strong>Base Field: Financial Year<\/strong>\u00a0and press <strong>OK<\/strong>. \u00a0So it will read the &#8220;<em>Difference from the previous Financial Year<\/em>&#8221;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/show-values-as.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3021\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/show-values-as.jpg\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/show-values-as.jpg 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/show-values-as-300x257.jpg 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span>\u00a0To <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-error-values-in-an-excel-pivot-table\/\" target=\"_blank\" rel=\"noopener\">format the values<\/a> you need to select the Pivot Table and go to <em><strong>Pivot Table Tools &gt; Analyze\/Options &gt; Select &gt; Entire Pivot Table<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/select-entire-pivot-table.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3022\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/select-entire-pivot-table.jpg\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"438\" height=\"257\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/select-entire-pivot-table.jpg 438w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/select-entire-pivot-table-300x176.jpg 300w\" sizes=\"(max-width: 438px) 100vw, 438px\" \/><\/a><\/p>\n<p>Then you need to once again go to\u00a0<em><strong>Pivot Table Tools &gt; Analyze\/Options &gt; Select <\/strong><\/em>but this time select the <em><strong>Values<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/select-values.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3023\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/select-values.jpg\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"438\" height=\"254\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/select-values.jpg 438w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/select-values-300x174.jpg 300w\" sizes=\"(max-width: 438px) 100vw, 438px\" \/><\/a><\/p>\n<p>Now press <strong>CTRL+1 to<\/strong> bring up the <em><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-1-format-cells\/\" target=\"_blank\" rel=\"noopener\">Format<\/a> Cell<\/em>s dialogue box and make your formatting changes within here and press <strong>OK. \u00a0<\/strong><\/p>\n<p><em>NB: This will fix the number format permanently and any new field that get added into the Pivot Table will have this format.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-cells.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3024\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-cells.jpg\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"525\" height=\"460\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-cells.jpg 525w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/format-cells-300x263.jpg 300w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 8:<\/strong><\/span>\u00a0To change the <em><strong>Sum of SALES2<\/strong><\/em> name within the Pivot Table, you need to <strong>click on a cell in the Pivot Table<\/strong> that contains <em>Sum of SALES2<\/em> and manually make the change, and press <strong>Enter<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/name-change.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3025\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/name-change.jpg\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"402\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/name-change.jpg 402w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/name-change-300x96.jpg 300w\" sizes=\"(max-width: 402px) 100vw, 402px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 9:<\/strong><\/span>\u00a0You need to <strong>select the whole column<\/strong> that contains the empty values and <strong>Right Click<\/strong> and select <strong>Hide<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/hide-column.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3026\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/hide-column.jpg\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"425\" height=\"489\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/hide-column.jpg 425w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/hide-column-261x300.jpg 261w\" sizes=\"(max-width: 425px) 100vw, 425px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You now have your Pivot Table, all formatted and showing the Difference from the previous Year:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/pivot-table-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3027 size-full\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/pivot-table-1.jpg\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"585\" height=\"406\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/pivot-table-1.jpg 585w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/pivot-table-1-300x208.jpg 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><\/p>\n<p>This will provide you with a Pivot Table year over year comparison in absolute terms!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"calculate-%-difference-between-two-columns\"><\/a>Calculate % Difference Between Two Columns<\/span><\/h3>\n<p>You can also show values as % Difference From. This will display the<strong> variance between two years in form of percentage<\/strong> instead of absolute value!<\/p>\n<p>&nbsp;<\/p>\n<p>Follow the steps below for <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-table-calculated-field\/\" target=\"_blank\" rel=\"noopener\">pivot table calculated field<\/a> difference between two columns:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Insert a Pivot Table by clicking on your data and going to<em><strong> Insert &gt; Pivot Table\u00a0<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23081\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"944\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296.png 944w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296-300x40.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-296-768x103.png 768w\" sizes=\"(max-width: 944px) 100vw, 944px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><em><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong><\/em>In the Create PivotTable dialog box, Select <strong>Table range<\/strong> and then click on <strong>New Worksheet<\/strong>. Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivot.png\" rel=\"attachment wp-att-2643\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2643\" title=\"Show The Difference From Previous Months With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivot.png\" alt=\"Show The Difference From Previous Months With Excel Pivot Tables\" width=\"387\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivot.png 387w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/pivot-300x253.png 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> <strong>Drag and down the following fields<\/strong> in the PivotTable Field dialog box:<\/p>\n<ul>\n<li>Sales Month in Rows Area<\/li>\n<li>Financial Year in Columns Area<\/li>\n<li>Sales in Values Area (Twice)<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-303.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23086\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-303.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"1319\" height=\"473\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-303.png 1319w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-303-300x108.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-303-1024x367.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-303-768x275.png 768w\" sizes=\"(max-width: 1319px) 100vw, 1319px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span>\u00a0<b>Right Click <\/b>on the<b> Sum of Sales2<\/b> column and select<b> Show Value As &gt; % Difference From.<\/b><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-301.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23087\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-301.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"940\" height=\"525\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-301.png 940w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-301-300x168.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-301-768x429.png 768w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> In the Show Value As dialog box, Select <strong>Financial Year as Base Field<\/strong> and <strong>(previous) as Base Item<\/strong>. Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-302.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23088\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-302.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"281\" height=\"128\" \/><\/a><\/p>\n<p>Sum of Sales2 will now display the difference in sales between 2 years in percentage!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-304.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23089\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-304.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"730\" height=\"443\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-304.png 730w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-304-300x182.png 300w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Hide the blank Column C. Select <strong>Column C &gt; Right Click and Select Hide<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-305.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23090\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-305.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"787\" height=\"465\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-305.png 787w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-305-300x177.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-305-768x454.png 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>And Voila! Your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Pivot Table difference between two columns<\/a> is now ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-306.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23091\" title=\"Show The Difference From Previous Years With Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-306.png\" alt=\"Show The Difference From Previous Years With Excel Pivot Tables\" width=\"628\" height=\"441\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-306.png 628w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/Screenshot-306-300x211.png 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/select-format-fields\/\" target=\"_blank\" rel=\"noopener\">Select &amp; Format Fields in Excel Pivot Tables<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-in-pivot-table\/\" target=\"_blank\" rel=\"noopener\">Index in Excel Pivot Tables<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/std-dev-in-pivot-table\/\" target=\"_blank\" rel=\"noopener\">Std Dev in Excel Pivot Tables<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"attachment noopener wp-att-1080 noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1080 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/728x90.gif\" alt=\"728x90\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the Calculate Difference between Two Pivot Tables option. You can show the values as the Difference From previous months, years, day, etc. \u00a0This is just great when your boss asks you how you are [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17229,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,18],"tags":[88,86,124],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3020"}],"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=3020"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3020\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17229"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}