Microsoft Office Tutorials and References
In Depth Information
More Pivot Table Examples
Figure 18-17 shows that the most common account opened by tellers is a Checking account.
h The AcctType field is in the Row Labels section.
h The OpenedBy field is in the Report Filters section.
h The Amount field is in the Values section (summarized by Count).
h A second instance of the Amount field is in the Values section (summarized by Percent of
Total).
Figure 18-17: This pivot table uses a Report Filter to show only the Teller data.
This pivot table uses the OpenedBy field as a Report Filter and is showing the data only for
Tellers. I sorted the data so that the largest value is at the top, and I also used conditional
formatting to display data bars for the percentages.
Question 6
How does the Central branch compare to the other two branches?
Figure 18-18 shows a pivot table that sheds some light on this rather vague question. It simply
shows how the Central branch compares with the other two branches combined.
h The AcctType field is in the Row Labels section.
h The Branch field is in the Column Labels section.
h The Amount field is in the Values section.
I grouped the North County and Westside branches together and named the group Other. The
pivot table shows the amount, by account type. I also created a pivot chart for good measure.
 
Search JabSto ::




Custom Search