Less Is More Blog Productivity Tips

Order your electronic copy of the survey report ($19.95 for a limited time)

Social Media Survey Report

The survey about the use of e-mail and Social Media has been completed and the survey report is now available. Learn more and order your copy!

Download Free eBook

The Results Curve(tm): How to Manage Focused and Collaborative Time.

Download now 

Get the Book at Amazon

Join our Free Webinars

Join us at the Workshops

Less-is-more Blog by Pierre Khawand

Current Articles | RSS Feed RSS Feed

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

Posted by Pierre Khawand on Mon, May 24, 2010 @ 10:39 AM
  
  
  
  
  
Add to delicious  delicious  
  
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


Tags: ,

Comments

Currently, there are no comments. Be the first to post one!
Post Comment
Name
 *
Email
 *
Website (optional)
Comment
 *

Allowed tags: <a> link, <b> bold, <i> italics

Subscribe by Email

Your email:

Write your comments!

We want to hear from you. Please write your comments in the blog and let us know what you think. We are eagerly awaiting your insights, tips, and suggestions!

Browse by Tag

Latest Posts