Microsoft Office Tutorials and References
In Depth Information
More Pivot Table Examples
Figure 18-13: This pivot table shows daily totals for each branch.
Which day of the week accounts for the most deposits?
Figure 18-14 shows the pivot table that answers this question.
h The Weekday field is in the Row Labels section.
h The Amount field is in the Values section and is summarized by Sum.
I added conditional formatting data bars to make it easier to see how the days compare.