Totals are performed in report builder mode and can be seen in the view mode of the report.
Performing totals on any column in the report
To perform totals on any column in the report:
- Go to the Report Builder.
- Hover on the column header where the total is to be performed. The down arrow displays in the right side of the column header.
- Select the down arrow. The column context menu appears.
- Select Show Totals. The Totals menu appears.
- Select Show grand totals.
- Select any arithmetic option, see table below.
- Select OK. The totals appear below the column header of the corresponding column.
Performing sub totals on any column in the report
Sub totals can be performed only when a report is already grouped by some column. Please refer to Grouping to see how grouping on a column is performed.
To perform sub totals on any column in the report:
- Go to the Report Builder.
- Hover on the column header where the sub totals are to be performed. The down arrow displays in the right side of the column header.
- Select the down arrow. The Column Header Context menu appears.
- Select Show Totals. The Totals menu appears.
- Select Show sub totals.
- Select any arithmetic option, see table below.
- Select OK. The sub totals appear below the column header for each group.
Arithmetic options
Arithmetic options on Totals / Sub totals vary depending on the column type as shown in the table.
Text Field | Number Field | Date Field | Date and Time Field | Time Field |
|---|---|---|---|---|
Count Count unique Count all | Count Count unique Count all Sum Average Max Min | Count Count unique Count all Max Min | Count Count unique Count all Max Min | Count Count unique Count all Max Min |