Progress
Report Builder
Tutorial
Creating Fields to Total the Sales of All Items for Each Representative
Now you are ready to create the fields that calculate the total of all sales for each sales representative or, in other words, the total for each column.
Follow these steps to create an aggregate field for each sales representative:
- Create an aggregate field, ARM–All–Total, using the settings listed in the following table:
Option Setting Type Total Field ARM–Sales Reset No–reset Accumulation Every Composite Processing Final PassThese settings instruct Report Builder to add all the values of ARM–Sales to calculate the total of all the items ARM sold.
- Create aggregate fields for each of the remaining sales representatives with the appropriate field, then return to the report layout. The remaining initials are BKO, JCO, MAR, MTW, PAM, PMB, SLA, and SMT.
The following Aggregate Fields dialog box shows the complete list of sales representative all total fields.
![]()
Make sure that you created all nine aggregate fields.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |