How to sort cross tab data

1	Select the cross tab, and on Property Editor, choose the Sorting tab.

2	On the Sorting page, choose Add.

Figure 17‑29

New Sort Key showing default sort values for the PRODUCTLINE dimension

By default, New Sort Key displays sort information for the first dimension in the column area, as shown in Figure 17‑29. The default Key value, PRODUCTLINE, indicates that the values in the PRODUCTLINE dimension are sorted by product line name in ascending order.

3	On New Sort Key, supply the necessary sort information, as follows:

1	In Group Level, select the dimension on which to sort.

2	In Key, select the data on which to sort. Although the typical choice is to sort on totals, you can also sort data by a specific dimension value. Depending on your choice, you may be required to provide additional information about the dimension level and value on which to sort.

3	In Direction, select Ascending or Descending. Choose OK to save the sort definition.

Figure 17‑30 shows an example of sorting on product line grand totals.

Figure 17‑30

New Sort Key specifying sorting on product line grand totals

Figure 17‑31 shows an example of sorting on a specific dimension value.

Figure 17‑31

Edit Sort Key specifying sorting on a dimension value