6.1.2 Sorting Multiple Columns

To sort multiple columns in a hierarchical fashion, follow these steps:

1. Press the 'Sort Column(s)' button in the table title bar. This opens the 'Sort Column' dialog box.

2. From the 'Sort on' drop-down menus, select the table columns that you wish to sort.

The hierarchical sort order of a column is determined by the verti­cal position of the menu. The column specified in the top menu is sorted first, the column specified in the second-to-top menu is sorted second, and so on.

3. For each column, select the 'Ascending' or 'Descending' button to determine the sorting direction.

When a column is sorted, its sort order is indicated by the small arrow next to the column name in the column header cell. To sort just a single column, see Sorting a Single Column.

Example: Sorting Multiple Columns  >>

Say you have a table listing the information of all of our customers and you would like to sort the data based on the state first, and then the city. To sort both the 'state' and the 'city' columns of the table, follow these steps:

1. Create a new Worksheet.

2. Expand the 'Data Source' node, and the 'Orders' node.

3. Drag the 'customers' query on to an empty cell in the Worksheet. This creates a new table named 'customers1'.

4. Press the 'Sort column(s)' button in the table title bar. This opens the 'Sort Column' dialog box.

 

5. Select 'state' from the first drop-down list, and ensure that the 'Ascend' radio button is selected.

6. Select 'city' from the second drop-down list, and ensure that the 'Ascending' radio button is selected.

 

7. Click on the 'OK' button. Notice that the up arrows next to the column names 'state' and 'city' indicate that both of those columns are sorted in ascending order.

 

8. Preview the table. Notice that the data is sorted by the 'state' and the 'city' columns.

 

 

<< 6.1.1 Sorting a Single Column © 1996-2013 InetSoft Technology Corporation (v11.4) 6.2 Filtering >>