FIGURE 1.24
Creating a PivotTable.A new form based on the data source opens in PivotTable view (see Figure 1.25), with the Field
List open so you can drag fields to the drop zones of the PivotTable, one field each to the Row
Fields, Column Fields, and (optionally) Filter Fields drop zones, which are indicated in gray text at
the upper-left corner of the form. The data field to be displayed in the body of the table is dragged
to the drop zone in the center of the form; Access will automatically create a Count or Sum field
when appropriate.See Chapter 5 of my book, Expert One-on-One Microsoft Application Development, for
more information on creating and using PivotTables and PivotCharts.Figure 1.26 shows the PivotTable with Salesperson selected as the Row field and CategoryName as
the Column field, with Price as the Totals field.CROCROSSSS-REF-REF
Part I The Office Components and What They Do Best