Microsoft Office Tutorials and References
In Depth Information
More Pivot Table Examples
Figure 18-18: This pivot table (and pivot chart) compares the Central branch with the other two branches
combined.
Question 7
In which branch do tellers open the most checking accounts for new customers?
Figure 18-19 shows a pivot table that answers this question. At the Central branch, tellers opened
23 checking accounts for new customers.
h The Customer field is in the Report Filters section.
h The OpenedBy field is in the Report Filters section.
h The AcctType field is in the Report Filters section.
h The Branch field is in the Row Labels section.
h The Amount field is in the Values section, summarized by Count.
This pivot table uses three report filters. The Customer field is filtered to show only New, the
OpenedBy field is filtered to show only Teller, and the AcctType field is filtered to show only
Checking.
 
Search JabSto ::




Custom Search