Excel 2010 Bible

Chapter 34: Introducing Pivot Tables

709

FIGURE 34.13

This pivot table shows daily totals for each branch.

Question 2

Which day of the week accounts for the most deposits?

Figure 34.14 shows the pivot table that answers this question.

l (^) The Weekday field is in the Row Labels section.
l 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.
Cross-Reference
See Chapter 20 for more information about conditional formatting. n