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

Show & Hide Field List in Excel Pivot Table Have you ever had the scenario where you are working on your Pivot Table and the Field List disappears? Lots of Excel users get annoyed with this but luckily I'm here to help you out 🙂 If your Pivot Table Field List disappears, you can easily bring it back as I show you be...
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...
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 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...