Home > Sample chapters > Microsoft Office > Excel

Analyzing Microsoft Excel 2010 Data with PivotTable Reports

Sorting PivotTable Fields

You can sort a PivotTable field either by its own items (for example, alphabetizing the categories in Figure 23-11) or on the basis of values in the body of the table (for example, sorting categories in descending order of sales totals so that the best-selling categories appear at the top). To sort a field, right-click any item in that field, and then click Sort. On the menu that appears, you can specify how you want to sort (for example A to Z or Z to A in the case of a text column). If you want to sort the field by values in the body of the table, click More Sort Options. You’ll see a dialog box similar to the one shown here (with the name of the field you selected in the title of the dialog box).

httpatomoreillycomsourcemspimages1741530.jpg

To sort by values in the table body instead of by items in the selected field, open the Ascending or Descending list. The list will include the available value fields.