Show Table Totals In CRM Analytics

When creating tables in CRM Analytics Widgets and Lenses, it’s possible to add Totals to rows and columns – it’s just not always obvious where to do this for CRMA newbies, or even for experienced developers. It’s tucked away a bit.

First, create a Lens or Widget. By default, you will be presented with a Chart. Click on the options up towards the top right-hand corner of the screen. If you select Table, you will be presented with three options:

  • Values Table
  • Compare Table
  • Pivot Table

When you select one of these tables you’ll notice a new box to the right appear, which looks like the below:

Totals for Tables in CRM Analytics

This new box is the Totals selector.

When on a Values Table you’ll get the option to ‘Show Totals’

When on a Compare Table you’ll get the option to ‘Show Totals’ and/or ‘Show Subtotals’

When on a Pivot Table you’ll get the option to ‘Show Column Totals’ and/or ‘Show Row Totals’

Totals appear at the top of the top, Subtotals appear at the bottom of each grouping – this position can’t be changed. It would be nice to have Totals at the bottom but hey-ho.

Bonus: remember that once you have sorted your data by Groups then Groups can be ordered in Ascending or Descending Order. To do this click on the upside-down arrow to the end of the Measure you want to sort by – see below. Next, select whether you want to sort groups ascending or descending.

Here’s a link to the Salesforce documentation for details of adding totals to tables on CRM Analytics – Table Properties (salesforce.com)

Ian Jamieson avatar

Leave a Reply

Your email address will not be published. Required fields are marked *