Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Creating PivotTables - Pg. 384

Analyzing Data with PivotTables and PivotCharts 384 Building a PivotTable is similar to building a form or a report in that you drag fields from a field list to populate the PivotTable with data. For a PivotTable, you add fields to specific areas of the PivotTable--areas defined for row fields, column fields, data fields, and filter fields (if you're using one or more fields as a filter). Each of these areas is outlined and labeled. The PivotTable menu and the PivotTable toolbar include commands you use to manage the data in a PivotTable, format a PivotTable, and set PivotTable properties. We'll describe how to work with the data in a PivotTable and how to format a PivotTable's elements in the sections that follow. In the field list, select Country, drag it to the top left of the window, and drop it in the area labeled Drop Filter Fields Here. Notice that when the field enters the labeled area, the area's border turns bright blue to indicate that the field is within that area. In the field list, fields that are included in the PivotTable are displayed in boldface. Select ProductName in the field list, and then drag this field to the area at the left side of the PivotTable, labeled Drop Row Fields Here. At this point, the PivotTable should look like the following: 6. 7.