Specifications

CHAPTER 9 Filtering, Sorting, and Grouping Rows
Users Guide 313
The General property page for the group displays in the Properties view.
3 Click the ellipsis button next to the Group Sort property.
The Specify Sort Columns dialog box displays.
4 Drag the column you want to sort the groups by from the Source Data box
into the Columns box.
If you chose a numeric column, InfoMaker uses the
Sum function in the
expression; if you chose a non-numeric column, InfoMaker uses the
Count
function.
For example, if you chose the
Salary column, InfoMaker 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.