Click to Sort
In addition to the temporary sort, you can sort the spreadsheet and barchart views by clicking the column headings.
When the Click to Sort option is enabled, you can click the column headings and toggle the sort operation between ascending or descending order. A small arrow displays when you click the column heading of a view. This shows the direction of the sort.
To sort the data for multiple columns:
- Non-adjacent columns: Ctrl + Click on the column headings until you have defined the entire sort expression.
- Adjacent columns: Shift + Click on the column headings until you have defined the entire sort expression.
When you sort columns based on a primary table in multi-table views, the Click to Sort option records the temporary sort in the Temporary Sort Expression dialog box. If you sort a spreadsheet based on a secondary table, the sort expression displays in the Sort column on the Define Link tab of the Spreadsheet Preferences dialog box.