Skip to main content
Returns the grand total for the given aggregate expression or column. Equivalent to Subtotal(aggregate, “grand_total”). Category: aggregate Syntax:
Returns: Float Context Filtering: ✗ No

​
Parameters

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

Return the sum of [Amount] across the whole dataset.
Return the grand total of [Count] column.
Last modified on March 13, 2026