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
pane.
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.
Figure 10-21:
A pivot table
can count
occurrences of
certain data,
such as the
number of
different
products
sold by
each
salesperson.
 
Search JabSto ::




Custom Search