Excel 2010 Bible

Chapter 34: Introducing Pivot Tables

711

FIGURE 34.16

This pivot table counts the number of accounts that fall into each value range.

This pivot table is unusual because it uses only one field: Amount.

l The Amount field is in the Row Labels section (grouped).

l (^) The Amount field is also in the Values section and is summarized by Count.
l A third instance of the Amount field is the Values section, summarized by Percent
of Total.
When I initially added the Amount field to the Row Labels section, the pivot table showed a row
for each unique dollar amount. I right-clicked one of the Row Labels and chose Group from the
shortcut menu. Then I used the Grouping dialog box to set up bins of $5,000 increments.
The second instance of the Amount field (in the Values section) is summarized by Count. I right-
clicked a value and chose Summarize Data By ➪ Count from the shortcut menu.
I added another instance of Amount to the Values section, and I set it up to display the percentage.
I right-clicked a value in column C and chose Show Values As ➪ % of Grand Total. This option is
also available in the Show Values As tab of the Value Field Settings dialog box.

Question 5

What types of accounts do tellers open most often?

Figure 34.17 shows that the most common account opened by tellers is a Checking account.

l The AcctType field is in the Row Labels section.

l (^) The OpenedBy field is in the Report Filters section.