Returns the grand total for the given aggregate formula. This function is shorthand for Subtotal(aggregate, "grand_total").

Syntax

GrandTotal(aggregate)

Parameters

Term Description
aggregate

An aggregate formula

Examples: Count(), Sum([Sales Amount])

Examples

Example #1

GrandTotal(CountDistinct([Product Type]))
  • Calculates the grand total of the aggregate function.
  • The calculation is shown in the tooltip, but is usable anywhere an aggregate formula is allowed.

    company apps

See Also

Subtotal
PercentOfTotal