Total Subscribers Receiving Our Weekly Excel Lessons



Sort by Largest or Smallest With Excel Pivot Tables

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

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!



Related Posts:

Sort Largest to Smallest Grand Totals With Excel P...   I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort from largest to smallest with Grand Totals! Below I have an Excel Pivot Tab...
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...
5 Speedy Steps To An Excel Pivot Table! G'day All, In this free downloadable Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps. If you want to learn more about Pivot Tables, join me in this Free P...
Group By Month With Excel Pivot Tables Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year. Grouping these would take a ton of effort using ...
Searching... Searching...

If so, join over 45,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis!

Click here to subscribe

Leave a Comment

Your email address will never be published. Required fields are marked with *