Add a grand total
Grand totals summarise measures across the entire report and are supported in table and matrix reports, where they can be added as rows or columns depending on the report format.
Subtotals are managed differently from grand totals and depend on how data is grouped in the report. To add a subtotal to a report, see Sorting and subtotals.
💡 Grand total rows and columns appear only when all records in a report are loaded. If a table report contains more than 1,000 rows or a matrix report contains more than 1,000 records, grand totals are hidden. To show them, select Load more in the blue banner at the top of your report until all records are loaded, or export the report.
In this article:
Add a grand total to a table report
- Open the report you want to add a grand total to
- Toggle the Show grand total checkbox
⚠️ The Show grand total checkbox will only appear when at least one dimension and measure are added to a report.
Add a grand total to a matrix report
- Open the report you want to add a grand total to
- Select Edit
- Select the first field in the Columns or Rows section of the Selected fields pane
- Toggle the Show totals checkbox in the selected field window
- Select OK
Need more support?
If you get stuck or have additional questions, you can contact our team directly through the Help widget in the bottom-right corner — we typically respond within one business day.