Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleClick to view instructions...
  1. Click on the Column Formatting menu in the main navigation bar of the page
  2. Select the field you wish to style the total of in the Report Fields list panel on the left of the menu
  3. Open the Summary section of the menu to view the available options
  4. Set Style to Custom
  5. Apply the formatting you wish to use. This will only customise the look of the total cell for the field selected.

Sub Total

 

Wiki Markup
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/nj9riz3u1Bk?color=white" frameborder="0" allowfullscreen></iframe>{html}

Expand
titleClick to view instructions...

Sub Totals are used when there are multiple records per category, possibly caused by having multiple dimension fields in a table, and it would be beneficial to view a total value for each category value. The example shown here could use a sub total for Year, as there are multiple rows per year value due to the Quarter field.

Note: in order to have a sub total display, you must have a total applied to the column you wish to populate the sub total row. For example, in the table above you will set the sub total on the Year category field, but you will have the total applied to the Invoiced field.

  1. Click on the Column Formatting menu in the main navigation bar of the page
  2. Select the category you wish to create a sub total for in the Report Fields list panel on the left of the menu
  3. Open the Summary section of the menu to view the available options
  4. Set Sub Total to On.
  5. You will now have a sub total row for each category value, populated by any metric that already has a total applied to it.

When using Sub Totals, we often pair this functionality with the Suppress Duplicates option, to make the report output easier to consume. To apply this option:

  1. Click on the Column Formatting menu in the main navigation bar of the page
  2. Select the category you applied the sub total to in the Report Fields list panel on the left of the menu
  3. Set the Suppress Duplicates option to On.
  4. You will now have a clearer report output

...