Sorting data


show more Sorting data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Sorting data

When you display your data in a Pivot Table, you might want to display all of the rows in the Pivot Table but change the order in which they are displayed. In this Pivot Table, for example, I have revenue for two companies, FirmA and FirmB, broken out by year and by month. At present, the Pivot Table is sorted by Year and then by Month and in the column areas we have FirmA and FirmB, which is the alphabetical order for those two company names. The data in the body of the Pivot Table occurs in the order mandated by the Year, the Month and the Companies. There is no internal order to it. But let's say that you wanted to display the highest monthly revenue values within the body of the Pivot Table.

To do that, you can click any cell in the column by which you want to sort. In this case, I will make it FirmA for 2008, and then on the toolbar click either Sort in ascending order, which puts the lowest values on top and the highest values on the bottom, or in descending order, which puts t...

Sorting data
Video duration: 2m 15s 1h 7m Intermediate

Viewers:

Sorting data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...