The GrandTotal formula returns the grand total for the given aggregate formula. GrandTotal is shorthand for Subtotal(aggregate, "grand_total").



Function arguments:

  • aggregate (required) - The aggregate formula to use in the function.

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


In a chart visualizing order counts per Product Type and Region, you can add a calculated column with the formula to the tooltip:

GrandTotal(CountDistinct(\[Product Type\]))

Β To see an overall total count of distinct orders across all categories.

  • The calculation is shown in the tooltip in this example, but is usable anywhere an aggregate formula is allowed.
    company apps

Related resources