GrandTotal - Anlytic

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

Name	Type	Required	Description
`aggregate_or_column`	`any`	✓ Yes	The 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 6, 2026