Worksheet columns can be sorted in ascending or descending order, and the sorted column position can be further ordered in the Sort Worksheet dialog.
Any worksheet, including imported datasets and the results of an analysis can be sorted. Sorting a worksheet has two different effects, depending on the type of worksheet that is sorted.
•Sorting a source worksheet, creates a permanent change in the way the worksheet is ordered. It affects all operational objects that use that worksheet so they are marked as out-of-date.
•Sorting a results worksheet only changes the order in which the data is displayed. If users want to make permanent changes to the way a results worksheet is sorted, then that worksheet can be copied to the Data folder or mapped to a Column Transformation object.
To sort a worksheet
Click the Sort Worksheet 
(Sort Worksheet icon) button that is located above every worksheet.
Or select Edit > Sort Worksheet.
In the dialog, click the Sort Direction arrow next to a column name to select a sort direction. Sort direction options include Ascending (increasing) or Descending (decreasing). Changing the sort direction changes the column order in the dialog, but does not change the sort order in the worksheet.
Select a sorted column in the dialog and move it up or down in the list by clicking the Up and Down arrow buttons.
When finished, click OK to apply the changes and close the dialog, or click Apply to apply the changes and leave the dialog open.
Click Clear Sort to clear all specified sort orders.
Note:If a column has no specified sort direction, then the column order cannot be changed in this dialog. However, the column order can still be changed in the Columns tab.
