A summary field is one of the following:
» sum
» average
» count
» maximum
» minimum
of the values of a database field.
Instructions
- Select the Summary tab in the Catalog.
- Click the
 New icon to add a summary field.
- Name the field total.
- Select Retail Sales ::price as the Summary Field.
- Select Sum as the Summary Function.
- Select Group #1 [Client] as the When Group Changes Reset option.
- Click the Apply button.
- Click the Close button.
- Drag the total field into the Group Footer section.
- Use the Number tab on the Properties dialog to select the Currency display and enter $
as the Currency symbol and 0 Decimals.
- Drag a Literal field to add the text 'Total' before total.
|
