Excel 2010 Bible

Chapter 35: Analyzing Data with Pivot Tables

741

FIGURE 35.30

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 requires 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 click Edit Custom Lists. Click New List, type your list

entries, and click Add. Figure 35.31 shows the custom list I created for the region names.

FIGURE 35.31

This custom list ensures that the Region names are sorted correctly.