This macro can be used to sort series and groups. Risers and labels can be sorted by ascending/descending series, groups, series totals, group totals, or by a user-specified order defined within the data set. For a user-specified sort order (nSort = 10 or 11), define the order in which to sort groups in the first series column of the data set. You can use the @IS macro to eliminate the first series if you do not want the sort order series to appear in the chart.
SYNTAX:
@SORT nSort
PARAMETERS:
nSort; 0...11 selects one of the following sorting options:
nSort
Sort Order
0
Sort Series Labels in Alphabetical order (a...z)
1
Sort Series Labels in Reverse Alphabetical order (z...a)
2
Sort Groups Labels in Alphabetical order (a...z)
3
Sort Groups Labels in Reverse Alphabetical order (z...a)
4
Sort Series Totals in ascending numeric value (i.e. total all values in each series. Then 'rank' the series from smallest total to largest).
5
Sort Series Totals in descending numeric value
6
Sort Groups Totals in ascending numeric value
7
Sort Groups Totals in descending numeric value
8
First Series Key to Groups Ascending
9
First Series Key to Groups Descending
10
Sort Groups ascending according to the values specified in the Series 1 column of the data set
11
Sort Groups descending according to the values specified in the Series 1 column of the data set
EXAMPLE: @SORT.RPT
@SORT 0
@SORT 1
@SORT 2
@SORT 3
@SORT 4
@SORT 5
@SORT 6
@SORT 7
@SORT 8
@SORT 9
@SORT 10
@SORT 11
PERSISTENT:
NO
Next Macro Previous Macro Return to Alpha List
Next Macro in this Group Previous Macro in this Group Return to Group List