{"id":3853,"date":"2019-01-02T18:10:34","date_gmt":"2019-01-02T18:10:34","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3853"},"modified":"2024-03-28T12:03:16","modified_gmt":"2024-03-28T12:03:16","slug":"percentages-in-a-pivottable","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/","title":{"rendered":"Percentages in a PivotTable"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-45f05df2-8ee0-4561-85d6-f2b357081e63\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Percentages-in-a-PivotTable.xlsx\">Percentages-in-a-PivotTable<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Percentages-in-a-PivotTable.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-45f05df2-8ee0-4561-85d6-f2b357081e63\">Download File<\/a><\/div>\n\n\n\n<p>In a PivotTable, you can create fields that will show you the percentage change of the previous value. This is especially popular in companies that want to see how did the sales changed compared to the previous month.<\/p>\n\n\n\n<p>We are going to use the following example.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"297\" height=\"300\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png\" alt=\"\" class=\"wp-image-3854\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Calculate the percentage difference<\/h2>\n\n\n\n<p>In order to know how the sales changed from month to month, you have to follow these steps.<\/p>\n\n\n\n<ol>\n<li><a href=\"https:\/\/officetuts.net\/excel\/examples\/copy-and-paste-columns\/\">Copy the <strong>Sales<\/strong> column<\/a> to column <strong>C<\/strong> and name it <strong>Change<\/strong>.<\/li>\n\n\n\n<li>Click any cell inside the table.<\/li>\n\n\n\n<li>Navigate to <strong>Insert &gt;&gt; Tables<\/strong> and click <strong>PivotTable<\/strong>.<\/li>\n\n\n\n<li>When the <strong>Create PivotTable<\/strong> window appears, click <strong>OK<\/strong> without changing any options.<\/li>\n\n\n\n<li>Inside the <strong>PivotTable fields<\/strong> check all the fields.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"261\" height=\"241\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-fileds.png\" alt=\"\" class=\"wp-image-3855\"\/><\/figure>\n\n\n\n<ol start=\"6\">\n<li>You can see in the newly created table, that you have two fields with the same values but different names.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"367\" height=\"321\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-same-fields.png\" alt=\"\" class=\"wp-image-3856\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-same-fields.png 367w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-same-fields-300x262.png 300w\" sizes=\"(max-width: 367px) 100vw, 367px\" \/><\/figure>\n\n\n\n<ol start=\"7\">\n<li>Right-click any fields inside the <strong>Sum of Change<\/strong> and choose <strong>Show Values As &gt;&gt; % Difference From\u2026<\/strong>.<\/li>\n\n\n\n<li>Change <strong>Base Item<\/strong> to <strong>(previous)<\/strong>. It will compare the difference between this month and the previous one. This difference will be displayed in percentages.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"281\" height=\"127\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/show-values-as.png\" alt=\"\" class=\"wp-image-3857\"\/><\/figure>\n\n\n\n<ol start=\"9\">\n<li>Click <strong>OK<\/strong> to see the result.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"367\" height=\"321\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-percentage-change.png\" alt=\"\" class=\"wp-image-3858\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-percentage-change.png 367w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-percentage-change-300x262.png 300w\" sizes=\"(max-width: 367px) 100vw, 367px\" \/><\/figure>\n\n\n\n<p>To make this PivotTable even more interesting, select all the values inside the <strong>Sum of Change<\/strong> field and navigate to <strong>Home &gt;&gt; Styles<\/strong>. Click <strong>Conditional Formatting &gt;&gt; Color Scales<\/strong> and choose the first option.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"367\" height=\"379\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/color-scales.png\" alt=\"\" class=\"wp-image-3859\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/color-scales.png 367w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/color-scales-291x300.png 291w\" sizes=\"(max-width: 367px) 100vw, 367px\" \/><\/figure>\n\n\n\n<p>This is how the PivotTable looks like.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"367\" height=\"321\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-conditional-formatting.png\" alt=\"\" class=\"wp-image-3860\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-conditional-formatting.png 367w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/pivot-table-conditional-formatting-300x262.png 300w\" sizes=\"(max-width: 367px) 100vw, 367px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In a PivotTable, you can create fields that will show you the percentage change of the previous value. This is especially popular in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Percentages in a PivotTable<\/title>\n<meta name=\"description\" content=\"Learn how to calculate percentage differences in Excel PivotTables. Use this guide to see how your sales changed compared to the previous month.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Percentages in a PivotTable\" \/>\n<meta property=\"og:description\" content=\"Learn how to calculate percentage differences in Excel PivotTables. Use this guide to see how your sales changed compared to the previous month.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-02T18:10:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T12:03:16+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Percentages in a PivotTable\",\"datePublished\":\"2019-01-02T18:10:34+00:00\",\"dateModified\":\"2024-03-28T12:03:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/\"},\"wordCount\":231,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/\",\"name\":\"Percentages in a PivotTable\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png\",\"datePublished\":\"2019-01-02T18:10:34+00:00\",\"dateModified\":\"2024-03-28T12:03:16+00:00\",\"description\":\"Learn how to calculate percentage differences in Excel PivotTables. Use this guide to see how your sales changed compared to the previous month.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Percentages in a PivotTable\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Percentages in a PivotTable","description":"Learn how to calculate percentage differences in Excel PivotTables. Use this guide to see how your sales changed compared to the previous month.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/","og_locale":"en_US","og_type":"article","og_title":"Percentages in a PivotTable","og_description":"Learn how to calculate percentage differences in Excel PivotTables. Use this guide to see how your sales changed compared to the previous month.","og_url":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/","article_published_time":"2019-01-02T18:10:34+00:00","article_modified_time":"2024-03-28T12:03:16+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Percentages in a PivotTable","datePublished":"2019-01-02T18:10:34+00:00","dateModified":"2024-03-28T12:03:16+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/"},"wordCount":231,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/","url":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/","name":"Percentages in a PivotTable","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png","datePublished":"2019-01-02T18:10:34+00:00","dateModified":"2024-03-28T12:03:16+00:00","description":"Learn how to calculate percentage differences in Excel PivotTables. Use this guide to see how your sales changed compared to the previous month.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/percentages-example.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/percentages-in-a-pivottable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Percentages in a PivotTable"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3853"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3853"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3853\/revisions"}],"predecessor-version":[{"id":15483,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3853\/revisions\/15483"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}