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:

DOWNLOAD EXCEL WORKBOOK

 

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!

HELPFUL RESOURCE:

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin