Analyzing Microsoft Excel 2010 Data with PivotTable Reports
- 8/31/2010
- Introducing PivotTables
- Creating a PivotTable
- Rearranging PivotTable Fields
- Refreshing a PivotTable
- Changing the Numeric Format of PivotTable Data
- Choosing Report Layout Options
- Formatting a PivotTable
- Displaying Totals and Subtotals
- Sorting PivotTable Fields
- Filtering PivotTable Fields
- Changing PivotTable Calculations
- Grouping and Ungrouping Data
- Displaying the Details Behind a Data Value
- Creating PivotCharts
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](/content/images/chap23_9780735626881/elementLinks/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.