Summary totals are included in a table either before or after the body of your report, separate from the report data. You can add summary totals for any fields in the topic that the report is based on. You can also add summary totals to grouped columns if you have grouping applied.
To add summary totals to your report:
- Click the Totals button in the report designer.
- Go to the Summary Totals tab.
- Click the Add button and select Total or Custom Total from the drop-down list.
- Total allows you to add a summary total to any field in your report's topic. Custom Total allows you to build a custom expression to calculate your total. You can configure the following settings for summary totals:
- Configure the following settings:
- Field: Select the field to add totals to in the drop-down list. You can add summary totals for any field from the report topic, even if it isn’t one of the report columns.
- Input Label: Enter a name for the total that will show in the report output.
- Function: Select one of the predefined functions from the list, or select Custom to create a custom expression to calculate a total. See Custom Totals.
- Display Totals: Select the At the top or At the bottom checkbox to specify whether the totals are included at the top bottom of your report data.
- Add Summary Totals to grouped data: Select the checkbox to include summary totals with the grouping information.
- Show only totals: Select this checkbox to generate a report output that contains only the totals.