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