Subtotal

Returns the subtotal for an aggregate expression or column using the specified mode and, optionally, partition/group columns. Category: aggregate Syntax:

Subtotal([aggregate_or_column], mode, |partition_by_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 subtotal. If a column is provided, it will be used directly.
`mode`	`text`	✓ Yes	Subtotal mode (‘grand_total’, ‘column’, ‘row’, etc.).
`partition_by_column`	`column`	✗ No	Partition/group column for subtotal (required for some modes).

Validation

Minimum parameters: 2
Maximum parameters: 3

Examples

Subtotal(Avg([Price]), "column", [ProductType])

Returns subtotal average price for each Product Type column.

Subtotal([Revenue], "column", [Region])

Returns subtotal of [Revenue] column for each Region.

Last modified on March 13, 2026

StDevP Sum

Aggregate Functions

Date Functions

Logical Functions

Math Functions

Text Functions

Type Functions

Window Functions

Parameters

Validation

Examples

​Parameters

​Validation

​Examples

Parameters

Validation

Examples