Category Group Properties Dialog Box, Sorting
SQL Server 2008 R2
Select Sorting on the Category Group Properties dialog box to specify a sort order for the unique values in this category group.
Click to add a new sort clause to the list.
Click to delete a selected sort clause.
Click to move the selected sort clause up in the list.
Click to move the selected sort clause down in the list.
Select the field on which you want to sort, or enter an expression to specify the sort order.
Select A to Z if you want to sort from the lowest to highest; for example, from 1 to 100. Select Z to A if you want to sort from the highest to the lowest; for example, from 100 to 1.