Sorting PivotTable data


show more Sorting PivotTable data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Sorting PivotTable data

When you summarize your data in the PivotTable you might want to display all of the rows in the PivotTable, but change the order in which they appear. So let's say for example that I have PivotTable here that contains sales data for two companies, broken down by month for the years 2009 and 2010. The current PivotTable arrangement organizes the data first by year and the years are sorted in numerical order, so 2009, 2010, and then the months are sorted January, February, March and so on, in order of the months as they occur in the year, as opposed to an alphabetical order.

But let's say that I wanted to sort the data inside the PivotTable from highest to lowest. So let's say for example that I wanted to find the months where FirmB had the highest sales within the year 2009. To do that I click any cell in the field and in the column that I want to sort and then on the Options contextual tab of the ribbon in the Sort and Filter group, I can click one of three buttons. I can cli...

Sorting PivotTable data
Video duration: 2m 0s 3h 43m Intermediate

Viewers:

Sorting PivotTable data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

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