Progress
Results User’s Guide
for Windows


Creating Aggregate Totals and Subtotals

Follow these steps to create one or more aggregate totals and subtotals:

  1. Choose Field Aggregates. The Field Aggregates dialog box appears:
  2. 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.

  3. Repeat Step 2 to create additional aggregates.
  4. When you are finished creating aggregates, choose OK.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095