Totals and subtotals

Add row totals, column totals, and subtotals to your pivot tables and charts.

Turn totals on

In the visual cell's right sidebar, find the Totals control under Visual options.

• One-click on/off: click the eye icon to add — or hide — row totals, column totals and any applicable subtotals in a single click.

Customise individual totals

Click the customise icon next to the toggle to expand the controls into a 2×2 grid:

• Rows → Grand Totals — a single column on the right aggregating across all columns.
• Rows → Totals — a subtotal column at every level above the leaf in a row hierarchy. For a hierarchy of Region → Country, you'll see a subtotal column for each region.
• Columns → Grand Totals — a single row at the bottom of the visual aggregating across all rows.
• Columns → Totals — the same behaviour on the column hierarchy.

How total values are calculated

Totals and subtotals are recomputed from the underlying rows — not aggregated from the visible data. That matters for non-additive aggregations:

• Averages show the true mean across all rows, not the mean of the displayed means.
• Distinct counts show the distinct count over the broader rollup, not the sum of child distinct counts.
• Sums, counts, mins, maxes, medians and percentiles behave the same way — each total is computed over the expanded row set.

Number formatting (currency, percentage, decimals) is inherited from each column. Filters on the visual still apply, so totals always agree with the rows shown.

Visuals that support totals

Totals work on any visual with a row or column hierarchy, including pivot tables, heatmaps and bar, line and area charts.