Sort Crosstab dialog

Use this tab to change the default sort order of items on the current crosstab worksheet. For example, you might want to order numerical sales data from highest to lowest to analyze at sales performance.

For more information, see:

"About sorting on crosstab worksheets"

"How to sort data on a crosstab worksheet"

"Examples of sorting"

Item to sort

Use this list to select the item on which you want to sort. For example:

• if you have Region on the left axis, you might select Region to sort profit data vertically

• if you have Year on the top axis, you might select Year to sort profit data horizontally

Note: Group sorts automatically take precedence over non-group sorts.

Sort Details for <worksheet item>

Use this table to specify sort details for the worksheet item selected in the Item to sort list.

Data Point

Use this field to specify the data point on which you want to sort. For example, you might choose Profit SUM to order data by the amount of profit.

Row or Column

Use this field to specify which row or column you want to sort, as follows:

• if you specify an item on the left axis in the Data Point field, you specify which column you want to use to sort the worksheet

  For example, you might have Region on the left axis and Year on the top axis. If you choose Region in the Data Point field, you choose which Year column you want to sort (e.g. 1998, 1999, 2000).

• if you specify an item on the top axis in the Data Point field, you specify which row you want to use to sort the worksheet

  For example, you might have Region on the left axis and Year on the top axis. If you choose Year in the Data Point field, you choose which Region row you want to sort (e.g. Central, East, West).

Note: This field is blank if the sort item is not a data point.

Direction

Use this drop down list to change how the data is ordered.

• Low to High sorts A - Z alphabetically and 1 - 10 etc. numerically (language specific).

• Hi to Low sorts Z - A alphabetically and 10 - 1 etc. numerically (language specific).

Default sort on row/column headings

Use this drop down list to choose a default sort order.

Add

Use this button to add a new sort to the Sort details for table. Use the Data Point, Row/Column, and Direction fields to specify sort details.

Delete

Use this button to remove the sort currently selected in the sort list from the Sort details for table.

Move up

Use this button to change the order of precedence of the selected sort item. Moving a sort up the list increases its precedence.

Move down

Use this button to change the order of precedence of the selected sort item. Moving a sort down the list decreases its precedence.

Notes

• You can also drag and drop items into a difference position in the sort list to change the order of precedence.