Microsoft Office Tutorials and References
In Depth Information
• The Weekday field is in the Rows section.
• The Amount field is in the Values section and is summarized by Sum.
I added conditional formatting data bars to make it easier to visualize how the days compare.
Figure 18-15: This pivot table shows totals by day of the week.
How many accounts were opened at each branch, broken down by account type?
Figure 18-16 shows a pivot table that answers this question.
• The AcctType field is in the Columns section.
• The Branch field is in the Rows section.
• The Amount field is in the Value section and is summarized by Count.