Microsoft® Office Access™ 2007 Plain & Simple

Adding and Removing PivotTable Fields

After you create a PivotTable, you can arrange the fields on the PivotTable to present your data effectively. It is possible your colleagues could ask questions you hadn’t thought of, but that you could answer if you included another field in the PivotTable and used it to filter or organize your data. Maybe they’re interested in how dairy products have been selling in South America. While you didn’t include the countries for each sale in the original PivotTable design, that data is in the query on which you based the PivotTable. All you need to do is add it to the design. By the same token, you can remove any fields you’re not using. You can drag them from the body of the PivotTable to the PivotTable Field ...