Display Totals

The Display Totals at the bottom of the report option is available for Money, Number, ID, and Text fields

By default, the Display Totals option is not selected for any all field type(s).  If the Display Totals option is selected for a field, the field will be underlined.

For Money and Number fields will insert a line at the bottom of the report and show the summation for that specific value of all rows on the report.  

For ID and Text fields will insert a line at the bottom of the report and show the count of all values or all unique values within that column for all rows on the report.

Follow the steps below to change the Display Totals option for fields.

  1. Select Reports > Builder.

  2. Use the Show All button to view all custom reports. Or use the Search field to further drill down your search.

  3. Select the Report from the list.

  4. Right-click on the field after it has been dragged onto the Columns pane and select Display Totals from the menu list.

If one or more fields on the report is grouped and the Display Totals option is enabled for a specific field, the subtotals for the field within each group will be displayed on the report along with the Grand Total for the report.