Page 13 of 16PREVNEXT

PivotTable II: Swing into action with PivotTable reports

Figure looking at a road disappearing into the hills in the background, and signs along the road with the names of different functions to summarize data

Sum is just one of the ways PivotTable reports can summarize numerical data.

Oh, and when you meet with your manager, here's a chance to show off just a bit.

PivotTable reports automatically summarize numerical data by adding it up (or counting it, which is another story altogether), but you can change how the data is summarized.

Suppose that during your meeting your manager wanted to know not only how much each salesperson sold, but the count of how many individual sales each salesperson has made.

To find the count, you would click any cell in the data area, click the Field Settings button Button image on the PivotTable toolbar, and then make a selection from the Summarize by list to count, or find the average, or find the maximum or minimum, or any of various other possibilities.

Page 13 of 16PREVNEXT