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

Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button.The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Slicer Styles & Settings There are several different Slicer Styles available for you when you click on an Excel Slicer.These Slicer Styles add color to your Excel workbook to gives it some much needed life!You can also add columns to a Slicer and you can also find more Slicer options by Right...
Errors When Grouping By Dates With Excel Pivot Tab... In our Group By Date post, we grouped our sales numbers by weeks.However there are times when we try to group by Dates and we get an error message!  That is frustrating!Instead of checking the dates one by one to find out where the error occurred, I will show you a cool w...
Insert Blank Rows In a Pivot Table Pivot Table reports are shown in a Compact Layout format as a default and if you have two or more Items in the Row Labels (e.g.Month & Customer), then the Pivot Table report can look very clunky...There is a cool little trick that most Excel users do not know about th...