Pinterest Pixel

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that... read more

Download Excel Workbook
Bryan
Posted on

Overview

Sort Largest to Smallest Grand Totals With Excel Pivot Tables | MyExcelOnline Sort Largest to Smallest Grand Totals With Excel Pivot Tables | MyExcelOnline

I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even Excel Pivot Table Sort by Grand Total!

Below I have an Excel Pivot Table that consists of Sales Numbers over a three-year period.

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

 

Want to know How To Show Excel Pivot Table Sort by Grand Total?

 

Watch Sort Pivot Table by Grand Total on YouTube and give it a thumbs-up!

Sort Largest to Smallest Grand Totals With Excel Pivot Tables | MyExcelOnline

Follow the step-by-step tutorial on Excel Pivot Table Sort by Grand Total and download this Excel workbook to practice along:

download excel workbookSort-Largest-to-Smallest-Grand-Totals.xlsx

In the example below I show you how to Sort by Largest to Smallest based on Grand Totals.

STEP 1: Select any cell in the data table.

Show The Percent of Grand Total With Excel Pivot Tables

 

STEP 2: Insert a new Pivot table by clicking on your data and going to Insert > Pivot Table.

Show The Percent of Grand Total With Excel Pivot Tables

 

STEP 3: Insert a new Pivot In the Create PivotTable dialog box, select the table range and New Worksheet, and then click OK.

Show The Percent of Grand Total With Excel Pivot Tables

 

STEP 4: In the ROWS section put in the Sales Month field, in the COLUMNS put in the Financial Year field and in the VALUES area you need to put in the Sales field:

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

 

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

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

(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)

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

 

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

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

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

This completes our tutorial on How to Sort Grand Total in Pivot Table!

Further Learning:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it
Sort Largest to Smallest Grand Totals With Excel Pivot Tables | MyExcelOnline Sort Largest to Smallest Grand Totals With Excel Pivot Tables | MyExcelOnline
Sort Largest to Smallest Grand Totals With Excel Pivot Tables | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Expand and Collapse Fields in Pivot Chart in Excel

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...