Column totals are included in the body of data in your report output. If you have grouped data, you can include totals with each grouping, but it isn’t necessary to have grouping in order to include column totals. You can configure them to be included at the top or at the bottom of the columns or groupings.
To add column totals to your report, click the Totals button in the report designer and go to the Column Totals tab in the slide-out panel. You can configure the following settings for column totals:
- Fields: You can add column totals to any fields that are included in the report.
- 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 Column Totals to grouped data: Select the checkbox to display totals with the grouping information.
- Show only totals: Select this checkbox to generate a report output that contains only the totals. Individual records are hidden.