Skip to main content
Returns the percent of total for the aggregate expression or column. Equivalent to aggregate / Subtotal(aggregate, mode, parameters). Category: aggregate Syntax: 
PercentOfTotal([aggregate_or_column], |mode|, |parameters|)
Returns: Float Context Filtering: ✗ No

​
Parameters

NameTypeRequiredDescription
aggregate_or_columnany✓ YesThe aggregate function (e.g., Sum([Sales])) or column to base percent calculations on. If a column is provided, it will be used directly.
modetext✗ NoPercent mode (‘grand_total’, ‘column’, etc.).
parametersany✗ NoAdditional parameters for subtotal if available (such as partition/group column).

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 3

​
Examples

PercentOfTotal(Sum([Sales]), "column", [Category])
Returns percent of total sales grouped by Category. 
PercentOfTotal([Revenue], "column", [Region])
Returns percent of total for [Revenue] column by Region.
Last modified on March 13, 2026