Microsoft Office Tutorials and References
In Depth Information
Another Pivot Table Example
This workbook, named county data.xlsx , is available on the companion CD-ROM.
Figure 18-42: This table contains data for each county in the United States.
Figure 18-43 shows a pivot table created from the county data. The pivot table uses the Region
and State Name fields for the Row Labels and uses Census 2000 and Census 1990 as the values.
I created three calculated fields to display additional information:
h Change (displayed as Pop Change): The difference between Census 2000 and Census
h Pct Change (displayed as Pct Pop Change): The population change expressed as a
percentage of the 1990 population.
h Density (displayed as Pop/Sq Mile): The population per square mile of land.
You might want to document your calculated fields and calculated items. Choose PivotTable Tools ➜
Options ➜ Calculations ➜ Fields, Items, & Sets ➜ List Formulas, and Excel inserts a new worksheet
with information about your calculated fields and items. Figure 18-44 shows an example.