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|)
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])
Subtotal([Revenue], "column", [Region])
Last modified on March 13, 2026
