Microsoft Office Tutorials and References
In Depth Information
Creating a Pivot Table
● Source data: The data used to create a pivot table. It can reside in a worksheet or an
● Subtotals: A row or column that displays subtotals for detail cells in a row or column in a
pivot table. The pivot table in the figure displays subtotals for each branch.
● Table Filter: A field that has a page orientation in the pivot table — similar to a slice of a
3-D cube. You can include any number of items (or all items) in a page field at one time. In
the figure, OpenedBy represents a page field that displays the New Accts item.
● Values area: The cells in a pivot table that contain the summary data. Excel offers several
ways to summarize the data (sum, average, count, and so on).
The following steps create the pivot table presented earlier in this chapter (see the “A Pivot Table
Example” section). For this example, I drag the items from the top of the PivotTable Field List to
the areas in the bottom of the PivotTable Field List.
1. Drag the Amount field into the Values area. At this point, the pivot table displays the
total of all the values in the Amount column of the data source.
2. Drag the AcctType field into the Row Labels area. Now the pivot table shows the total
amount for each of the account types.
3. Drag the Branch field into the Column Labels area. The pivot table shows the amount for
each account type, cross-tabulated by branch (see Figure 18-9).