Microsoft Office Tutorials and References
In Depth Information
Figure 18-16: This pivot table uses the Count function to summarize the data.
So far, the pivot table examples have all use the Sum summary function. In this case, though, I changed the
summary function to Count. To change the summary function to Count, right-click any cell in the Values area
and choose Summarize Data By ⇒ Count from the shortcut menu.
What's the dollar distribution of the different account types?
Figure 18-17 shows a pivot table that answers this question. For example, 253 (or 35.53%) of the new accounts
were for an amount of $5,000 or less.
This pivot table is unusual because it uses three instances of a single field: Amount.
• The Amount field is in the Rows section (grouped, to show dollar ranges).
• The Amount field is also in the Values section and is summarized by Count.
• A third instance of the Amount field is the Values section, summarized by Percent of Total.