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 for Mac 2011 Essential Training show less
please wait ...

Summarizing more than one data field

When most users visualize a PivotTable, they see it with a single data set in the data area. While that's certainly the most common configuration, you can summarize more than one data field at a time. For example, let's take a look at the PivotTable I have on the screen right now. I have a single bit of information in the data area, and that is the revenue for each of my companies broken down by month, by year, and so on. But let's say that I wanted to add a second data field to that area, and I have added a field to this PivotTable, and it is Customers, and that's the number of new customers that were picked up during an individual month.

I can drag the Customers field down into the Values area. I'll drop it below the Sum of Revenue. And when I drop it, it appears inside the body of the PivotTable. So now, we have two fields: we have the revenue, and we have the customers. If I wanted to change their order and look at Customers first, I could drag Sum of Revenue below...

Summarizing more than one data field
Video duration: 1m 34s 6h 32m Beginner

Viewers:

Summarizing more than one data field provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

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