Specify the Query Results Sort Order

Use the Order pane on the Account Analysis page to specify the sort order for the data returned in the query results. For example, if desk and customer appear in the Order pane, the query results sort first by desk and then by customer within the desk.

To specify the sort order for query results

1. Ensure that a query is open on the Account Analysis page.

2. In the Data Selection tree, expand nodes to locate the data item to include as a column.

3. Drag and drop the data item into the Select Columns pane.

4. Continue adding data items as necessary.

Note: You can sort by aggregate data by dragging the aggregated column from the Select Columns pane and dropping it into the Order pane. For more information about aggregating data, see Assign an Aggregate Function to a Column.

5. To delete a data item from the sort, in the Order pane, click the data item and then click Delete.

6. To change the sort order, in the Order pane, click the data item and then click Move Up or Move Down.

7. To sort in ascending order, in the Order pane, click the data item and then click Order Asc.

8. To sort in descending order, in the Order pane, click the data item and then click Order Desc.

Related Topics

Query Results

Create an Account Analysis Query

Modify an Account Analysis Query

Account Analysis