Query Studio

Sorting Data in Query Studio

You can organize the data in a report by specifying a sort order. Data can be organized in ascending or descending sort order based on the values in any data item. You can sort the data in many different report elements.

To sort data in Query Studio:

Open the Reports application.
Open the report in Query Studio.
Click the heading of the report item you want to sort on.
On the toolbar, click Sort .
At the top of the report, click the sort name to open the Sort section below the report.
In the Sort area, change the default sort order.
Note: Click a different heading to choose a different field on which to sort.
Click OK.
A small up or down arrow in the heading indicates sorted data.

Tips:

To remove sorting, under Sort order, click Don’t sort, and click OK.
You can delete a sorted column but keep the sort itself. Click the column you want to delete and click the delete button . The Delete dialog box appears, and you can choose to delete or keep filters and sorting associated with the column.