6.1.1 Sorting a Single Column
To sort a single column, do one of the following:

• Click the 'Sort' button in the column header. This sorts the column in ascending order. Click the button again to sort the column in descending order. Click a third time to return the column to its original order.

• Press the 'Sort Column(s)' button in the table title bar. This opens the 'Sort Column' dialog box, where you can specify the sort order for the selected column. See Sorting Multiple Columns for more information on using the dialog box.
When a column is sorted, its sort order is indicated by the small arrow next to the column name in the column header cell.
Assume you have a table displaying the sales information for all states and you would like to sort the data based on the ascending order of the states. Follow these steps:

1. Create a new Worksheet.
2. Expand the 'Data Source' node, and the 'Orders' node.
3. Drag the 'sales by state' query on to an empty cell in the Worksheet. This creates a new table named 'sales by state1'.
4. Select the 'State' header cell.

5. Click on the 'Sort' button, located next to the column name in the column header cell. Notice the presence of an up arrow next to the 'state' column name in the table.

6. Preview the table.

7. Close the 'Preview' window, and select the 'State' column header again.
8. Click on the 'Sort' button. Notice that the 'State' column will now be sorted in descending order. This is indicated by the down arrow present next to the column name.

9. Preview the table.

Clicking on the 'Sort' button of the 'State' column a further time will result in the data being displayed in its original order.
10. Now select the 'Sales' column header cell.
11. Click on the 'Sort' button. Notice that the 'Sales' column is now sorted in the ascending order and the 'State' column is no longer sorted. The 'State' column is set to display the data in its original order.

12. Preview the table.

| << 6.1 Sorting | © 1996-2013 InetSoft Technology Corporation (v11.4) | 6.1.2 Sorting Multiple Columns >> |