{"id":3745,"date":"2021-03-30T03:24:59","date_gmt":"2021-03-30T01:24:59","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3745"},"modified":"2024-02-06T15:48:53","modified_gmt":"2024-02-06T14:48:53","slug":"show-percent-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-percent-excel-pivot-tables\/","title":{"rendered":"Show The Percent Of With Excel Pivot Tables"},"content":{"rendered":"<p>Excel <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a> have a lot of useful\u00a0calculations under the <strong>SHOW VALUES AS<\/strong> option and one that can help you a lot is Add Percentage to Pivot Table.<\/p>\n<p>It will display the value of one item (<strong>the Base Field<\/strong>) as the percentage of another item (<strong>the Base Item<\/strong>).<\/p>\n<p>This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, expenses, attendance, or anything that can be quantified.<\/p>\n<p>In this example, you have a pivot table with Sales person in the row area and the year in the column area.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-313-e1617563684741.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone wp-image-23123 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-313-e1617563684741.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"719\" height=\"210\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-313-e1617563684741.png 719w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-313-e1617563684741-300x88.png 300w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><\/a><\/p>\n<p>There are two variations on the of % option:<\/p>\n<ul>\n<li><a href=\"#%-of-year\"><strong>% of Year<\/strong><\/a><\/li>\n<li><a href=\"#%-of-sales-person\"><strong>% of Sales Person<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at both these variations!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"%-of-year\"><\/a>% of Year<\/span><\/h3>\n\n<p>In the example below I show you how to get the\u00a0<em><strong>Percent of the Previous<\/strong><strong> Year&#8217;s Sales\u00a0<\/strong><\/em>i.e. each year&#8217;s sales will be compared to the sales for the previous year in form of a percentage!<\/p>\n<p>Watch how to calculate percentage in pivot table on <a href=\"https:\/\/youtu.be\/sSS5XCpskC8\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/sSS5XCpskC8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>Follow the<strong>\u00a0step-by-step tutorial<\/strong> on How to Add Percentage to Pivot Table\u00a0and <strong>download this Excel workbook<\/strong>\u00a0to practice along:<\/p>\n<p><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Percent-Of.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Percent-Of.xlsx<\/span><\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong>\u00a0<\/span>Insert a new Pivot table by clicking\u00a0on your data and going\u00a0to<strong><em>\u00a0Insert &gt; Pivot Table &gt; New Worksheet or Existing Worksheet<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-Of-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-3748\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-Of-01.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"386\" height=\"344\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-Of-01.png 386w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-Of-01-300x267.png 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0In the\u00a0<strong>ROWS<\/strong>\u00a0section put in the\u00a0<em>Sales\u00a0Person\u00a0<\/em>field, in the\u00a0<strong>COLUMNS<\/strong>\u00a0put in the <em>Financial\u00a0Year<\/em>\u00a0field and in the\u00a0<strong>VALUES\u00a0<\/strong>area you need to put in the\u00a0<em>Sales<\/em>\u00a0field twice, I explain why below:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-3749\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-02.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-02.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-02-167x300.png 167w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p>Here is how the Pivot Table Percentage looks like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-313-e1617563684741.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23123\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-313-e1617563684741.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"719\" height=\"210\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-313-e1617563684741.png 719w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-313-e1617563684741-300x88.png 300w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong>\u00a0<\/span>Click the second Sales field\u2019s\u00a0<em>(Sum of SALES2<\/em>) drop down and choose<strong>\u00a0Value Field Settings<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-3750\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-03.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-03.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-03-167x300.png 167w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span><strong>\u00a0<\/strong>Select the\u00a0<strong>Show Values As<\/strong>\u00a0tab and from the drop down choose\u00a0<em><strong>% of. \u00a0<\/strong><\/em><\/p>\n<p>For the <em>Base Field<\/em> pick\u00a0<strong>Financial Year.<\/strong><\/p>\n<p>For the <em>Base Item<\/em> pick\u00a0<strong>(previous)<\/strong>.<\/p>\n<p>This means we want to get the\u00a0<strong>% of\u00a0<\/strong>values based on the\u00a0<strong>previous Financial Year<\/strong>.<\/p>\n<p>Also, change the <strong>Custom Name<\/strong> into <em><strong>Percent of Previous Year<\/strong><\/em>\u00a0to make it more presentable.\u00a0Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-3751\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-04.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-04.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-04-300x257.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span>\u00a0Notice that the<strong><em> Percent of Previous Year<\/em>\u00a0<\/strong>data is in a decimal\u00a0format that is hard to read:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-05A.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-3752\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-05A.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"560\" height=\"175\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-05A.png 560w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-05A-300x94.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/a><\/p>\n<p>To format the <em><strong>Percent of Previous Year<\/strong><strong>\u00a0<\/strong><\/em>column, click the second\u00a0Sales field\u2019s\u00a0<em>(Percent of Previous Year<\/em>) drop down and choose<strong>\u00a0Value Field Settings.\u00a0<\/strong><\/p>\n<p>The goal here is for us to transform\u00a0numbers from\u00a0a decimal\u00a0format (i.e. 0.23), into a percentage\u00a0format that is more readable (i.e. 23%).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-05B.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-3753\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-05B.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"338\" height=\"591\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-05B.png 338w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-05B-172x300.png 172w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6: <\/strong><\/span>Click the <strong>Number Format<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-3754\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-06.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-06.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-06-300x257.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:\u00a0<\/strong><\/span>Inside the\u00a0<em>Format Cell<\/em>s dialog box, make your formatting changes within here and press\u00a0<strong>OK<\/strong>\u00a0twice.<strong> \u00a0<\/strong><\/p>\n<p>In this example, we used the\u00a0<strong>Percentage\u00a0<\/strong>category to make our <em>Percent of Previous Year<\/em>\u00a0numbers become more readable.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-3755\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-07.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"529\" height=\"465\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-07.png 529w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-07-300x264.png 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Following these steps you can add Percentage to Pivot Table, showing the <strong>Percent of Previous Year\u00a0<\/strong>for the sales data of years 2012, 2013, and 2014.<\/p>\n<p>All of the sales numbers\u00a0are now represented as a <strong>Percentage of the Previous Year\u00a0(Year 2013<\/strong> is represented as a <strong>Percentage of Year 2012<\/strong>, and <strong>Year 2014<\/strong> is represented as a <strong>Percentage of Year 2013)<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone wp-image-3756 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-08.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"876\" height=\"167\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-08.png 876w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-08-300x57.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Percent-of-08-768x146.png 768w\" sizes=\"(max-width: 876px) 100vw, 876px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"%-of-sales-person\"><\/a>% of Salesperson&#8217;s Sales<\/span><\/h3>\n<p>Instead of showing % of Year, you can even display<strong> % of Salesperson&#8217;s Sales<\/strong>\u00a0in the Pivot Table. Follow the steps below to do so:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Click on any cell in the data table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-314.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23127\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-314.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"688\" height=\"335\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-314.png 688w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-314-300x146.png 300w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Go to <strong>Insert<\/strong> &gt; <strong>Pivot Table<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-315.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23128\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-315.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"1053\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-315.png 1053w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-315-300x36.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-315-1024x124.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-315-768x93.png 768w\" sizes=\"(max-width: 1053px) 100vw, 1053px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>In the Create PivotTable dialog box, select the<strong> table range<\/strong> and <strong>New Worksheet<\/strong> and then click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-316.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23129\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-316.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"394\" height=\"253\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-316.png 394w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-316-300x193.png 300w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>In the PivotTable fields dialog box, drag and drop<strong> Sales person in Rows area<\/strong>, <strong>Year in Columns area<\/strong>, and <strong>sales amount in values area<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-322.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23132\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-322.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"256\" height=\"453\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-322.png 256w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-322-170x300.png 170w\" sizes=\"(max-width: 256px) 100vw, 256px\" \/><\/a><\/p>\n<p>A Pivot Table will be displayed on your worksheet!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-317.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23131\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-317.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"447\" height=\"159\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-317.png 447w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-317-300x107.png 300w\" sizes=\"(max-width: 447px) 100vw, 447px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5: <\/span><\/strong>Right Click on any value in the Pivot Table and select <strong>Value Field Setting<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-318.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23133\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-318.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"521\" height=\"436\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-318.png 521w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-318-300x251.png 300w\" sizes=\"(max-width: 521px) 100vw, 521px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6: <\/span><\/strong>In the Value Field Setting dialog box, Under <strong>Show Values As<\/strong> Tab select % Of &gt; SALES PERSON &gt; Homer Simpson.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-320.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23134\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-320.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"373\" height=\"318\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-320.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-320-300x256.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>This will add percentage to Pivot Table!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-2021-04-05-at-12.51.48-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Show The Percent Of With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23228\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-2021-04-05-at-12.51.48-AM.png\" alt=\"Show The Percent Of With Excel Pivot Tables\" width=\"433\" height=\"192\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-2021-04-05-at-12.51.48-AM.png 433w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Screenshot-2021-04-05-at-12.51.48-AM-300x133.png 300w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/a><\/p>\n<p>Excel will display 100% for all values for Homer and it will be compared to itself. For other salespersons, Excel will show sales amount as a percentage of Homer&#8217;s sales for that particular year.<\/p>\n<p>This completes our tutorial on how to show percentage in pivot table!<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2964 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/05\/728x90.gif\" alt=\"PIVOT BANNER\" width=\"728\" height=\"90\" title=\"\"><\/a><\/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","protected":false},"excerpt":{"rendered":"<p>Excel Pivot Tables have a lot of useful\u00a0calculations under the SHOW VALUES AS option and one that can help you a lot is Add Percentage to Pivot Table. It will display the value of one item (the Base Field) as the percentage of another item (the Base Item). This option will immediately calculate the percentages [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17186,"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,148,139,124],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3745"}],"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=3745"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3745\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17186"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}