Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Changing the View of Data in a Pivot... - Pg. 387

Analyzing Data with PivotTables and PivotCharts 387 Changing the View of Data in a PivotTable The PivotTable we created in the previous section is set up so that you can view the dollar amount of each order for Northwind products during the years 1996, 1997, and 1998. Viewed in a datasheet or as a PivotTable, this large set of data becomes more useful once it's summarized and filtered to show sets of data that meet specific criteria. In this section, we'll explain how to filter the data in a PivotTable. We'll also describe some of the operations that you can perform with a PivotTable so that you can gather more information from the data it presents. Filtering Data in a PivotTable Form One of the advantages of viewing data in a PivotTable is the ability to easily filter data. You can filter data by the fields you add to the filter field area as well as by values in the fields used in columns and rows. In the following steps, we'll demonstrate how to filter data in a PivotTable. As you'll see, even when a PivotTable displays a large set of data, you can filter to view details very quickly. Filter data in a PivotTable 1. 2. If the ProductsByCountry PivotTable form isn't open, select it in the Database window, and then click Open. In the PivotTable, click the Country field's drop-down arrow at the top left. A list of campaign countries appears, as shown here: