Add column totals—CRW

Wizard Step 5. Add more column totals

At this point in the process, you can select the column totals you want to include in the report.

About summary information

Only mathematical summaries can be performed on numeric data fields: Count, Sum, Average, Std Deviation, Variance, Largest, and Smallest.

Text fields are limited to Count summaries. For example, if you're creating a report about employees, you might include a Count for employees that shows the total number of employees.

Groupings affect the location in a report where calculations appear:

  • Without grouping: calculations display at the bottom of the report for the entire table.
  • With grouping: calculations display for each subgroup and for the entire table.
Subscription Customization Services or Platform Services
Regional availability

All regions
User type Business or Admin
Permissions Custom reports: List, View, Edit, Add, Delete

Add more totals

  1. Select Add more column totals in the Wizard.
    This option is commonly Step 5.
    Custom Report Wizard user interface page for adding more column totals.
  2. Select the checkbox for the total or totals on the line for the column, such as sum and average.
  3. Save your selection.
  4. Select Next to continue to Wizard Step 6. Sort columns.

Wizard steps reference

The steps for creating a CRW report can vary depending on the selections that you make in the Wizard.

The typical steps for creating a report with the Wizard are as follows:

  1. Select a primary data source.
  2. Add columns to the report.
  3. Add calculated columns.
  4. Specify the column order.
  5. Add column totals.
  6. Sort columns.
  7. Filter the report.
  8. Enable grouping.
  9. Group columns.
  10. Set report period and title.
  11. Define chart output.
  12. Include runtime prompts.
  13. Save and add the report to a menu or dashboard.