Chapter 29: Introducing PivotTables
29
■ (^) The Customer field is in the Filters section.
■ The OpenedBy field is in the Filters section.
■ (^) The AcctType field is in the Filters section.
■ The Branch field is in the Rows section.
■ (^) The Amount field is in the Values section, summarized by Count.
This PivotTable uses three report filters. The Customer field is filtered to show only New, the
OpenedBy field is filtered to show only Teller, and the AcctType field is filtered to show only
Checking.
Learning More
The examples in this chapter should give you an appreciation for the power and flexibility
of Excel PivotTables. The next chapter drills down a bit deeper and covers some advanced
features of PivotTables—with lots of examples.