Excel 2010 Bible

Part V: Analyzing Data with Excel

710

FIGURE 34.14

This pivot table shows totals by day of the week.

Question 3

How many accounts were opened at each branch, broken down by account type?

Figure 34.15 shows a pivot table that answers this question.

l (^) The AcctType field is in the Column Labels section.
l The Branch field is in the Row Labels section.
l (^) The Amount field is in the Values section and is summarized by Count.
The most common summary function used in pivot tables is Sum. In this case, I changed the sum-
mary function to Count. To change the summary function to Count, right-click any cell in the
Value area and choose Summarize Data By ➪ Count from the shortcut menu.
FIGURE 34.15
This pivot table uses the Count function to summarize the data.

Question 4

What’s the dollar distribution of the different account types?

Figure 34.16 shows a pivot table that answers this question. For example, 253 of the new accounts

were for an amount of $5,000 or less.