Sorting organizes your data in either ascending or descending alphabetical or numeric order. For example, you can sort on a column that lists product sales in descending order to rank product sales from the highest to the lowest.
When sorting grouped data, you can choose to sort the detail values or you can sort the summary values in the footers.
Open the report that you want in Query Studio.
Click the heading of the report item you want to sort on.
From the Edit Data menu, click Sort .
In the Sort dialog box, choose the desired sort options.
Click OK.
A small up or down arrow in the heading indicates sorted data.
Tips
To remove sorting, from the Edit Data menu, click Sort, then 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.