GrandTotal
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.