Part V: Analyzing Data with Excel
740
FIGURE 35.29This pivot table was created from the county data.
I created three calculated fields to display additional information:l (^) Change (displayed as Pop Change): The difference between Census 2000 and Census
1990
l (^) Pct Change (displayed as Pct Pop Change): The population change expressed as a per-
centage of the 1990 population
l (^) Density (displayed as Pop/Sq Mile): The population per square mile of land
Tip
To view (or document) calculated fields and calculated items in a pivot table, choose PivotTable Tools ➪
Options ➪ Calculations ➪ Fields, Items & Sets ➪ List Formulas. Excel inserts a new worksheet with information
about your calculated fields and items. Figure 35.30 shows an example. n