Filter
Top Products
CHAPTER 9 Filtering, Sorting, and Grouping Rows
DataWindow Designer User’s Guide 283
For example, if you chose the
Salary column, DataWindow Designer
specifies that the groups will be sorted by the expression
sum(salary for
group 1)
:
5 Select ascending or descending sort as appropriate.
6 If you want to modify the expression to sort on, double-click the column
in the Columns box.
The Modify Expression dialog box displays.
7 Specify the expression to sort on.
For example, to sort the department group (the first group level) on
average salary, specify
avg(salary for group 1).
8 Click OK.
You return to the Specify Sort Columns dialog box with the expression
displayed.
9 Click OK again.
At runtime, the groups will be sorted on the expression you specified.