You can sort any column of information in Detail Drilldown to suit your needs.

A black triangle in the column header indicates which column/s is being sorted and whether the sort is in ascending or descending order. More than one column can be sorted at the same time (multi column sort).

Simply left click on the column header you wish to sort.

Initially the sort will be in ascending order (i.e. arrow will point up). To swap to descending order (i.e the arrow will point down) click on the header again.

If you want to remove the sort, click the header once more and the black triangle will disappear.

Each time you click on a column to sort - AQX will retain any current sort unless you remove it first. If you leave the current sort on screen and click on a 2nd column - the data will be sorted first by the original column and then by the 2nd column. I.e. if you already have the Media column with a black triangle on and click on Date - it will sort first by the media and then by the date within that media

To remove the sort on the original column (if not required) keep clicking on the header until the black triangle disappears. Then click on the column you wish to sort by.

TIP - If you don't like the Sub Totals in your Quick Sort - go into Advanced Sorting and uncheck Show Sub Totals. See below for more on Advanced Sorting

Show To do more Advanced Sorting

Right click on a field column header and select Advanced Sorting

This will open an Advanced Sorting dialog.

Use the Select or Remove buttons to choose the field or fields to sort by and the order of that sort.
Click on the black arrow beside each field name to set ascending (arrow pointing up) or descending (arrow pointing down) order
OPTIONAL: Check on Show Sub Totals if required (this will only show sub totals for the first item listed under Sorted Columns.)
Click Apply

Click to Enlarge

Show To Clear Sorting

There are 3 methods

Keep clicking on each column header until the black triangle disappears -OR-
Right click on a column header, select Advanced Sorting, click on Clear button and hit Apply. This option will take you back to the default sort
Right click on a column header, select Advanced Sorting, click on the field in Sorted columns you need to remove, click on the Remove button, repeat for all fields in Sorted Columns, then click Apply.

See Also