Sorting on multiple columns
You can sort data by up to three columns. When you sort by multiple columns, you use the Advanced Sort dialog box, as shown in
Figure 4‑4.
Figure 4‑4 Specifying advanced sorting
When sorting data on multiple columns, it is important to understand the order of precedence for the sort. On Advanced Sort, select the columns in the order in which to sort data. For example, to sort data by city first, then by customer name, you must select the columns in that order on Advanced Sort.
How to sort data on multiple columns
1 Select a column. You can select any column in the table.
2 Right‑click the selected column, then choose Sort➛Advanced Sort from the context menu.
3 On Advanced Sort, select a column from the first drop‑down list, and choose either Ascending or Descending order.
4 Select another column from the second drop‑down list, and choose the sort order.
5 Optionally, select a third column on which to sort.
Figure 4‑4 shows the sort criteria for the report design in
Figure 4‑2.
