O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required