Microsoft® Office Access™ 2007 Plain & Simple

Filtering PivotTable Data

When you create a PivotTable from the data in your tables or queries, you often have several screens worth of data to move through. Reorganizing your data can help you interpret your data, but you can also filter your PivotTable by choosing the data you want to see. For example, if your PivotTable shows sales data for a series of products grouped by category, you can pick the categories for which you want to view data.

Select Which Field Values to Display

1. Display the forms in your database.

2. Double-click the PivotTable form. ...