Microsoft Office Tutorials and References
In Depth Information
Organizing Lists in Pivot Tables
Summing a pivot table
A pivot table not only displays information, but it can also count the number
of occurrences of information, such as the number of sales per sales region.
To display a count of data, you need to move a heading in the Values group
inside the PivotTable Field List pane by following these steps:
1. Click the pivot table you want to modify.
The PivotTable Field List pane appears.
2. Click a heading that you want to count in the PivotTable Field List
A pop-up menu appears.
3. Click Move to Values.
Excel moves your chosen heading to the Values group inside the
PivotTable Field List pane and displays a count of items under your
chosen heading, as shown in Figure 10-21.
A pivot table
such as the