Pivoting a PivotTable report


show more Pivoting a PivotTable report 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 ...

Pivoting a PivotTable report

The real power of the Pivot Table comes out when you want to rearrange your data dynamically. A task that would take several minutes if done by hand takes just a few seconds when you summarize your data in a Pivot Table. The row and column headers provide the basic outline of your Pivot Table data. In this case, we have Year, and then we have companies: FirmA and FirmB. And the data in this cell represents FirmA sales for the year 2008. If you change the row and column header positions, you change the organization of data in your Pivot Table. For example, if I pivot the Company field header beside Year, then we'll see a different arrangement.

To do that, I move the mouse pointer over top of the field header. You see the grab-hand. Press down the left mouse button and drag the field until you see the vertical I-bar here to the right of Year. When I drop it, we're organized by year and now by company. If I wanted to organize the data by company and then by year, I would drag the Compa...

Pivoting a PivotTable report
Video duration: 2m 13s 1h 7m Intermediate

Viewers:

Pivoting a PivotTable report 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 ...