Home Reports How do I configure display, grand totals, and subtotals in a report?

How do I configure display, grand totals, and subtotals in a report?

Last updated on Oct 14, 2026

Short Answer: Open the 'Layout' tab, choose 'Display values as' Columns or Rows, toggle 'Show grand total row' / 'Show grand total column', and enable 'Row subtotals' or 'Column subtotals' when the report has multiple fields.

PreRequisites

  1. Add a data source to the report so rows/columns/values are available.

  2. At least two row or column fields are needed for subtotals.

Steps

  1. Open the 'Layout' tab in the right panel.
    Layout controls Display values, Grand totals, Subtotals, Sorting are visible.

  2. Under 'Display values as' select either 'Columns' or 'Rows'.
    Values layout updates accordingly.

  3. Toggle 'Show grand total row' or 'Show grand total column' as needed.
    Grand totals appear in the preview based on toggles.

  4. Enable 'Row subtotals' or 'Column subtotals' when you have more than one row or column field.
    Subtotals appear when the report has multiple row/column fields. Message: 'Subtotals are available when the report has more than one row or column field.'

Troubleshooting

  1. Subtotals toggles are not available or have no effect.
    LikelyCause: The report has fewer than two row or column fields.
    Action: Add additional row or column fields under the 'Rows' or 'Columns' tabs, then enable subtotals.

Note: Use the 'Sorting' area to control order after adding row, column, or value fields.