Total Subscribers Receiving Our Weekly Excel Lessons

+45,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

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

 

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:

 

Related Posts:

Sort by Largest or Smallest With Excel Pivot Table... 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 anywhe...
Group By Custom Dates With Excel Pivot Tables In my previous Group By Month post, we grouped our Sales by each month. However the cool thing with Excel is that we can take that a step further and customize our grouped date range! In the exa...
Group By Half Years With Excel Pivot Tables   In our previous post, we were able to Group by Month using Pivot Tables.  Let us take it up another notch, and group it by Half Years! In the example below I show you how to get the Sales...
Group By Time With Excel Pivot Tables Let's put yourself in my place for a second. It was a dark, rainy night in Dublin city and I was working overtime...again! I downloaded a report with lots of transnational data.  Time of Sale in...
Searching... Searching...

DO YOU WANT TO GET BETTER AT EXCEL?
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 *

Comments