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:



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.




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

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 anywhere!Let us start off with this Excel Pivot Table showing the Sum of SALES for...
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 example below I show you how to get the Sales Grouped by Custom Dates:  ...
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 Grouped by Half Years: January to June and July to December DOWNL...
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 one column and Sales in another, among other columns.I wanted to get the Sa...