Microsoft Office Tutorials and References
In Depth Information
• A second instance of the Amount field is in the Values section (summarized by Percent of Total).
Figure 18-18: This pivot table uses a report filter to show only the Teller data.
This pivot table uses the OpenedBy field as a 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 percent-
How does the Central branch compare with the other two branches?
Figure 18-19 shows a pivot table that sheds some light on this rather vague question. It shows how the Central
branch compares with the other two branches combined.
• The AcctType field is in the Rows section.
• The Branch field is in the Columns section.
• The Amount field is in the Values section.