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 Pivot Tables, is it allows me to sort virtually anywhere!

Let us start off with this Excel Pivot Table showing the Sum of SALES for each Year and Quarter.  Make sure to download the Excel Workbook below so that we will have the same starting point.

In the example below I show you how to Sort a Pivot Table by Largest or Smallest:



STEP 1: Right click on a Year cell within the Pivot Table.

Go to  Sort > Sort Newest to Oldest


This will sort our Years by descending order.  Notice that 2014 was sorted first.


STEP 2: Now let us try to sort by Quarters.

Right click any Quarter name within the Pivot Table.

Go to  Sort > Sort Newest to Oldest


This will sort our Quarters by descending order.  Notice that Quarter 4 was sorted first.


STEP 3: Now let us try for the Sum of SALES.

Right click on a sum value within the Pivot Table.

Go to  Sort > Sort Largest to Smallest


This will sort our sum of Sales by descending order, regardless of the Quarter.


It’s pretty cool on how Pivot Tables allows you to sort on any area that you want to!



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Sort an Item Row (Left to Right) With Excel Pivot ... I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort any row from left to right!! Below I have an Excel Pivot Table that consists of Sales Numbers over a three year period. Make sure to download the Excel Workbook b...
Pivot Table Count Transactions The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count. This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit. DOWNLOAD...
How To Insert a Pivot Table Slicer Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table. They are a new feature from Excel 2010 onward and Mac for Excel 2016 and a must for anyone wanting to wow their boss by adding interactivity i...
Microsoft Excel Pivot Tables Online Tutorial Pivot Tables are one of the most powerful features of Microsoft Excel. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly p...