PivotTable Wizard

See Also

Creates pivot tables. Pivot tables are interactive worksheet tables that allow you to summarize and analyze data from existing tables. You can choose either to save a pivot table directly in Microsoft Excel or to add one as an object on a form.

You must have Microsoft Excel with Microsoft Query installed on your computer in order to create a pivot table. For more information about pivot tables, see Microsoft Excel Help.

To run the PivotTable Wizard

• From the Wizards submenu on the Tools menu, choose PivotTable.

Wizard Steps

Step 1 – Select Fields
Step 2 - Layout
Step 3 - Finish

For more information, see "Using Wizards" in Chapter 1, Getting Started, in the User's Guide.