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 Table that consists of Sales Numbers over a three year period.

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 by Largest to Smallest based on Grand Totals:

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Right click on a Grand Total below at the bottom of the Pivot Table.  Go to  Sort > Sort Largest to Smallest

(If you cannot see the Grand Totals, click in your Pivot Table and go to the ribbon menu and select PivotTable Tools > Design > Grand Totals > On for Rows and Columns)

 

STEP 2: This will sort our grand totals by descending order.

See that our years are now arranged in this order: 2013, 2014, 2012.

 

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

Share on Google+

Google+

Related Posts

Show The Percent of Column Total With Excel Pivot ... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF COLUMN TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, ...
Sort an Excel Pivot Table Manually You have your Pivot Table ready, all sorted nicely both from a row and column perspective.  However you just need that one minor sorting tweak or two. Well, Excel seemingly has a lot of tricks and you can even sort an Excel Pivot Table manually! For our example, let's see t...
Show The Percent of Parent Total With Excel Pivot ...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT TOTAL calculation. In the example below I show you how to get the Percent of a Product Total i.e The % Sales of each Product ...
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...