<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=289291844809425&amp;ev=PageView&amp;noscript=1">
Less Is More Blog Productivity Tips

Join us at the Webinars


Click for our Webinars Schedule.

The Perfect 15-Minute Day Method is here!


Order the book, eBook, journal, or eCourse to get started right away and inject a healthy dose of accomplishments and happiness in your workday and beyond!

Learn more!

Get Our Free eBook

The Results Curve: How to Manage Focused and Collaborative Time

Less-Is-More Blog by Pierre Khawand

Accomplishing More With Excel: Sorting Excel PivotTable Reports using columns instead of grand totals

Posted by Pierre Khawand on Mon, May 24, 2010 @ 08:39 AM

When you are working with a PivotTable report, you can easily sort the report manually or alphabetically in ascending or descending order, but you can also sort it by ascending and desending order of the grand total as shown in the report below: 

PivotTable Sort Grand Total

But how about if you want to sort the report by the PowerPoint instead of the grand total?

There is a way:

First: Right-mouse click on any of the location field (or any of the location items such as San Francisco for instance) and then from the popup menu, select the "Sort" menu item, and then the "More Sort Options…" sub-menu item. The Sort (Location) window opens up. 

Second: Click the "Descending" option and select "Sum of Fee" from the dropdown box:

PivotTable Reports Sort Options

Third: Click the "More Options" button. The More Sort Options (Location) window opens up. Click the "Values in selected column" option and then enter the desired range (in this case if we want to sort by the values in the Excel column, this would be $D$5:$D$10):

More options in Excel PivotTables

Voila! Here is the resulting report

Excel PivotTable Reports sorted by column

Additional Resources

Topics: Microsoft Office 2007, Microsoft Excel Tutorial