Progress
Results User’s Guide
for Windows
Creating Aggregate Totals and Subtotals
Follow these steps to create one or more aggregate totals and subtotals:
- Choose Field
Aggregates. The Field Aggregates dialog box appears:
![]()
- Create a total or subtotal as follows:
- To create a total, select the field for which you want to calculate the total, select summary line from the Break-By Fields selection list, and select the aggregate value you want to create.
For example, to count all the orders in the report, select Order-Num from the Query Fields selection list, select summary line from the Break-By Fields selection list, then select Count.
- To create a subtotal, select the field for which you want to calculate the subtotal, select the sort field you want to use from the Break-By Fields selection list, and select the aggregate value you want to create.
For example, to calculate the total price of the items each customer ordered, select the Price field from the Query Fields selection list, select the Cust-Num field from the Break-By Fields selection list, then select Total.
- Repeat Step 2 to create additional aggregates.
- When you are finished creating aggregates, choose OK.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |