Microsoft Office Tutorials and References
In Depth Information
I created three calculated fields to display additional information:
• Change (displayed as Pop Change): The difference between Census 2000 and Census 1990
• Pct Change (displayed as Pct Pop Change): The population change expressed as a percentage of the 1990
• 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 ⇒ Ana-
lyze ⇒ Calculations ⇒ Fields, Items, & Sets ⇒ List Formulas, and Excel inserts a new worksheet with information
about your calculated fields and items. Figure 18-46 shows an example.
Figure 18-46: This worksheet lists calculated fields and items for the pivot table.
This pivot table is sorted on two columns. The main sort is by Region, and states within each region are sorted
alphabetically. To sort, just select a cell that contains a data point to be included in the sort. Right-click and
choose from the shortcut menu.
Sorting by Region required some additional effort because Roman numerals are not in alphabetical order.
Therefore, I had to create a custom list. To create a custom sort list, access the Excel Options dialog box, click
the Advanced tab, and scroll down and click Edit Custom Lists. In the Custom Lists dialog box, select New
List, type your list entries, and click Add. Figure 18-47 shows the custom list that I created for the region