Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 7 Tables 279

Now you control the layout of the PivotTable. A PivotTable has four areas.

The Row Labels determine the categories that will appear in each row of

the table. Similarly, the Column Labels control the categories for each table

column. The Values area determines the values that will appear at each in-

tersection of row and column categories. Finally, the Report Filter area is

used to fi lter the PivotTable, showing only a subset of all of the data in the

selected data set.

You can design your PivotTable by dragging fi elds from the PivotTable

Field List box into these different areas. Try this now by creating a Pivot-

Table showing the breakdown of department categories in your data set.

To create a PivotTable of department categories:

1 Click Dept from the PivotTable Field List box and drag it to the Row

Labels area box.

Excel adds the different department categories to the PivotTable.

Now show the counts within each category.

list of fields that can be

added to the PivotTable

PivotTable areas

Figure 7-3

PivotTable

tools

PivotTable ribbon

blank PivotTable