To create a sorting definition:
Right-click a dimension member header and select Analysis Tools, then Sort.
The Sorting dialog box is displayed.
Select the dimension member to which sorting is applied, from Sort On.
Select Ascending or Descending.
Click Apply.
Click OK.