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

​
Parameters

NameTypeRequiredDescription
aggregate_or_columnany✓ YesThe aggregate function (e.g., Sum([Amount])) or column to calculate the grand total. If a column is provided, it will be used directly.

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

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