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 Sum of Customers.…I just find that to be easier than dragging one up to the top of the box; …