Summarizing more than one data field


show more Summarizing more than one data field 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 ...

Summarizing more than one data field

When most users think of a Pivot Table, they usually visualize it with a single data set in the data area. While that's certainly the most common data area configuration, you can also summarize more than one data field at a time. In this worksheet, for example, I have Company and Month in the row area and Year in the column area. There is a single data field and that is Revenue. If I want, I can add a second copy of the Revenue data field to the data area. To do that, I go to the PivotTable toolbar and drag the Revenue field to the data area. And Excel adds a second version of the Revenue field.

It's titled Revenue2. If I want to make any changes to that second Revenue field, I can do so by clicking any cell in that field and then, on the PivotTable toolbar, clicking the Field Settings button. I can then click Options and use the second data field as a means to compare the value in the first data field to other values in the Pivot Table. So, for example, if I wanted to show the dif...

Summarizing more than one data field
Video duration: 1m 55s 1h 7m Intermediate

Viewers:

Summarizing more than one data field 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 ...