{"id":4322,"date":"2021-03-08T23:37:31","date_gmt":"2021-03-08T22:37:31","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=4322"},"modified":"2024-05-21T19:43:42","modified_gmt":"2024-05-21T17:43:42","slug":"rank-largest-smallest-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/rank-largest-smallest-excel-pivot-tables\/","title":{"rendered":"Rank Largest to Smallest 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 the Excel Pivot Table <strong>RANK LARGEST TO SMALLEST\u00a0<\/strong>calculation.<\/p>\n<p>This option will immediately calculate the\u00a0rankings (1 being the LARGEST\u00a0value) for your values, allowing you to pinpoint the risks or opportunities quickly!<\/p>\n<p>It allows you to analyze data by ranking them and<strong> check what&#8217;s on top and what is at the bottom<\/strong>!<\/p>\n<p>You can easily do ranking in Pivot Table using either of the two methods mentioned below:<\/p>\n<ul>\n<li><a href=\"#using-sorting-option\"><strong>Using Sorting Option<\/strong><\/a><\/li>\n<li><a href=\"#using-calculated-field-option\"><strong>Using Calculated Field Option<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at these methods in-depth!<\/p>\n<p>&nbsp;<\/p>\n\n<p>In the example below I show you how to get the Excel Pivot Table <i>Rank Largest to Smallest<\/i>:<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/l5Jbak3XWPE?rel=0\" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<div class=\"after-post-box\">\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<\/div>\n<div class=\"after-post-box\">\n<p>&nbsp;<\/p>\n<\/div>\n<p>Follow the<strong>\u00a0step-by-step tutorial<\/strong> on Excel Pivot Table Rank Largest to Smallest and <strong>download this Excel workbook<\/strong>\u00a0to practice along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/Rank-from-Largest-to-Smallest.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <\/span><span class=\"postTitle px-3\">Rank-from-Largest-to-Smallest.xlsx<\/span><\/a><\/strong><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"using-sorting-option\"><\/a>Using Sorting Option<\/span><\/h3>\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\/08\/Rank-from-Largest-to-Smallest-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-4324\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-01.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"386\" height=\"344\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-01.png 386w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-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 Month\u00a0<\/em>field, in the\u00a0<strong>COLUMNS<\/strong>\u00a0put in the <em>Financial\u00a0Year<\/em> field, 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\/08\/Rank-from-Largest-to-Smallest-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-4325\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-02.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-02.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-02-167x300.png 167w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p>&nbsp;<\/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\/08\/Rank-from-Largest-to-Smallest-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-4326\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-03.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"354\" height=\"637\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-03.png 354w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-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<em><strong>\u00a0Rank Largest\u00a0to Smallest<\/strong><strong>. \u00a0<\/strong><\/em><\/p>\n<p>Select <strong>Sales Month<\/strong>\u00a0as the Base Field. This means that we will rank the Sales Values by the Sales Month (where Rank 1 is the Largest).<\/p>\n<p>Also change the\u00a0<strong>Custom Name<\/strong> into <strong>Rank Largest\u00a0to Smallest\u00a0<\/strong>to make it more presentable. \u00a0Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-4327\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-04.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-04.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-04-300x257.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You now have your Pivot Table, showing the <strong>Rank Largest\u00a0to Smallest\u00a0<\/strong>for the sales data of years 2012, 2013, and 2014.<\/p>\n<p>You can see that each red box is the ranking for each year (for Years 2012, 2013, 2014, and the Total Rankings).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone wp-image-4328 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-05.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"1006\" height=\"426\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-05.png 1006w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-05-300x127.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Rank-from-Largest-to-Smallest-05-768x325.png 768w\" sizes=\"(max-width: 1006px) 100vw, 1006px\" \/><\/a><\/p>\n<p>This is how you can easily Rank Pivot Table in few easy steps!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"using-calculated-field-option\"><\/a>Using Calculated Field<\/span><\/h3>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select any cell in the data and then 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\/10\/Screenshot-256.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22912\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-256.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"943\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-256.png 943w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-256-300x41.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-256-768x104.png 768w\" sizes=\"(max-width: 943px) 100vw, 943px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>In the dialog box, select <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\/10\/Screenshot-257.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22913\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-257.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"395\" height=\"252\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-257.png 395w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-257-300x191.png 300w\" sizes=\"(max-width: 395px) 100vw, 395px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong>\u00a0<\/span><span style=\"color: #000000;\">Drag and drop <strong>Sales Month in the Row field<\/strong> and<strong> Sales in the Values field<\/strong>.<\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-259.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22915\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-259.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"1349\" height=\"478\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-259.png 1349w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-259-300x106.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-259-1024x363.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-259-768x272.png 768w\" sizes=\"(max-width: 1349px) 100vw, 1349px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong>\u00a0<\/span><span style=\"color: #000000;\">Click on the filter button and Select <strong>More Sorting Option<\/strong>.<\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-262.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22916\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-262.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"359\" height=\"506\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-262.png 359w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-262-213x300.png 213w\" sizes=\"(max-width: 359px) 100vw, 359px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong>\u00a0<\/span>In the Sort dialog box, Select <strong>Sum of Sales in the Ascending by<\/strong> dropdown. Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-263.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22917\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-263.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"313\" height=\"306\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-263.png 313w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-263-300x293.png 300w\" sizes=\"(max-width: 313px) 100vw, 313px\" \/><\/a><\/p>\n<p>This will sort the data in ascending order!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22918\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"243\" height=\"382\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265.png 243w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265-191x300.png 191w\" sizes=\"(max-width: 243px) 100vw, 243px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong> <\/span>Click on any cell in the Pivot Table and Go to <strong>PivotTable Analyze<\/strong> &gt; <strong>Calculated Field<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265-Copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22920\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265-Copy.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"1148\" height=\"287\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265-Copy.png 1148w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265-Copy-300x75.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265-Copy-1024x256.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-265-Copy-768x192.png 768w\" sizes=\"(max-width: 1148px) 100vw, 1148px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong> <\/span>In the Insert Calculated Field dialog box, <strong>Type =1<\/strong> n the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> field. Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-266-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22922\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-266-1.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"446\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-266-1.png 446w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-266-1-300x207.png 300w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 8:<\/strong> <\/span>Right-Click on the calculated field and select <strong>Value Field Setting<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-268.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22923\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-268.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"554\" height=\"462\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-268.png 554w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-268-300x250.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 9:<\/strong>\u00a0<\/span>In the Value Field Setting dialog box, Select <strong>Running Total in<\/strong> as <strong>Show Value as<\/strong>! Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-269.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22925\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-269.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"373\" height=\"318\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-269.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-269-300x256.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>This will sort the values from largest to smallest and insert a rank field in the Pivot Table!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-270.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Rank Largest to Smallest With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-22926\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/Screenshot-270.png\" alt=\"Rank Largest to Smallest With Excel Pivot Tables\" width=\"272\" height=\"280\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\">Conclusion<\/span><\/h3>\n<p>In this tutorial, you have learned how to rank in pivot table by either using the Sorting option or by inserting a calculated field.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Make sure to download our FREE PDF on the<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=\"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","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 the Excel Pivot Table RANK LARGEST TO SMALLEST\u00a0calculation. This option will immediately calculate the\u00a0rankings (1 being the LARGEST\u00a0value) for your values, allowing you to pinpoint the risks or opportunities quickly! It allows [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17160,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Rank Largest to Smallest With Excel Pivot Tables","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,18],"tags":[88,173,124],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4322"}],"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=4322"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4322\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17160"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=4322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=4322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=4322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}