Totals Row Aggregation


You can add a row total for any numeric column in a table chart. Additionally, you can customize the aggregation type used for each column.

From within the Data Explorer, click the Chart Settings button.

Click Chart Settings within Data Explorer

Check the Show row aggregation for numeric columns checkbox and click Done when finished.

Click Show row aggregation for numeric columns

The total row will always display at the bottom of the chart, even if all of the rows don’t fit in the available chart space.

Total rows

You also have the option to show the row aggregation at the top of your chart. This can be done by checking the Show aggregation row at the top checkbox and clicking Done when finished.

Set custom aggregations for each column

The aggregation row defaults to sum for each numeric column. However, you can change the aggregation per column as needed.

To change the aggregation type, open the Chart Settings and switch to the Columns tab. Click the +Add New Formatting Rule button. Select your column from the dropdown and adjust the Aggregate Row setting to choose a custom aggregation.

Final result

Related Charts Help Articles

See more