Filter
Top Products
CHAPTER 9 Filtering, Sorting, and Grouping Rows
DataWindow Designer User’s Guide 281
To get the total salary of employees in a department, specify:
Sum( Salary for group 1 )
At runtime, you see this:
Sorting the groups
You can sort the groups in a DataWindow object. For example, in a
DataWindow object showing employee information grouped by department,
you might want to sort the departments (the groups) by total salary.
Typically, this involves aggregate functions, as described in “Adding summary
statistics” on page 279. In the department salary example, you would sort the
groups using the aggregate function
Sum to calculate total salary in each
department.