{"id":5881,"date":"2017-03-01T18:49:38","date_gmt":"2017-03-01T17:49:38","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5881"},"modified":"2024-02-06T15:46:52","modified_gmt":"2024-02-06T14:46:52","slug":"sort-by-largest-or-smallest-with-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-by-largest-or-smallest-with-excel-pivot-tables\/","title":{"rendered":"Sort by Largest or Smallest With Excel Pivot Tables"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>In the example below I show you how to Sort an Excel <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> by Largest or Smallest.<\/p>\n<p>&nbsp;<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Q0877uoX4Xg?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\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span>?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left;\"><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/youtu.be\/Q0877uoX4Xg\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\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=\"alignright 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>There are countless times when I had my Pivot Table all setup, but I was not really happy with how the data was sorted. The cool thing with 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>, is it allows me to sort virtually anywhere!<\/p>\n<p>Let us start off with this Excel Pivot Table showing the Sum of SALES for each Year and Quarter.\u00a0\u00a0In the example below I show you how to Sort a Pivot Table by Largest or Smallest:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort by Largest or Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5883\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-01.jpg\" alt=\"Sort by Largest or Smallest With Excel Pivot Tables\" width=\"215\" height=\"439\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-01.jpg 215w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-01-147x300.jpg 147w\" sizes=\"(max-width: 215px) 100vw, 215px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong>\u00a0<\/span>Right click on a <strong>Year<\/strong> cell within the Pivot Table.<\/p>\n<p>Go to <strong><em>\u00a0Sort &gt;\u00a0Sort Newest to Oldest<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort by Largest or Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5885\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-02.jpg\" alt=\"Sort by Largest or Smallest With Excel Pivot Tables\" width=\"453\" height=\"466\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-02.jpg 453w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-02-292x300.jpg 292w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This will sort our Years by descending order. \u00a0Notice that 2014 was sorted\u00a0first.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort by Largest or Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5886\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-03.jpg\" alt=\"Sort by Largest or Smallest With Excel Pivot Tables\" width=\"225\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-03.jpg 225w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-03-150x300.jpg 150w\" sizes=\"(max-width: 225px) 100vw, 225px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong>\u00a0<\/span>Now let us try to sort by <strong>Quarters<\/strong>.<\/p>\n<p>Right click any Quarter name within the Pivot Table.<\/p>\n<p>Go to <strong><em>\u00a0Sort &gt;\u00a0Sort Newest to Oldest<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort by Largest or Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5892\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-04.jpg\" alt=\"Sort by Largest or Smallest With Excel Pivot Tables\" width=\"437\" height=\"488\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-04.jpg 437w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-04-269x300.jpg 269w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This will sort our Quarters by descending order. \u00a0Notice that Quarter 4 was sorted\u00a0first.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort by Largest or Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5888\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-05.jpg\" alt=\"Sort by Largest or Smallest With Excel Pivot Tables\" width=\"223\" height=\"447\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-05.jpg 223w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-05-150x300.jpg 150w\" sizes=\"(max-width: 223px) 100vw, 223px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong>\u00a0<\/span>Now let us try for the <strong>Sum of SALES<\/strong>.<\/p>\n<p>Right click on a\u00a0sum value within the Pivot Table.<\/p>\n<p>Go to <strong><em>\u00a0Sort &gt;\u00a0Sort Largest to\u00a0Smallest<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-06.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort by Largest or Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5893\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-06.jpg\" alt=\"Sort by Largest or Smallest With Excel Pivot Tables\" width=\"556\" height=\"449\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-06.jpg 556w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-06-300x242.jpg 300w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This will sort our sum of Sales by descending order, regardless of the Quarter.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-07.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort by Largest or Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5890\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-07.jpg\" alt=\"Sort by Largest or Smallest With Excel Pivot Tables\" width=\"219\" height=\"442\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-07.jpg 219w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Sort-by-Largest-or-Smallest-07-149x300.jpg 149w\" sizes=\"(max-width: 219px) 100vw, 219px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>It&#8217;s pretty cool on how Pivot Tables allows you to sort on any area that you want to!<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5924 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot-300x170.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" alt=\"\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; In the example below I show you how to Sort an Excel Pivot Table by Largest or Smallest. &nbsp; \ufeff? Watch on YouTube and give it a thumbs up &#x1f44d; There are countless times when I had my Pivot Table all setup, but I was not really happy with how the data was sorted. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":15518,"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,42],"tags":[229,86,230,90],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5881"}],"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=5881"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5881\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/15518"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=5881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=5881"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=5881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}