ROLLUPGROUP
Applies to: Calculated column Calculated table Measure Visual calculation
Modifies the behavior of the SUMMARIZE and SUMMARIZECOLUMNS functions by adding rollup rows to the result on columns defined by the the groupBy_columnName parameter. This function can only be used within a SUMMARIZE or SUMMARIZECOLUMNS expression.
Syntax
ROLLUPGROUP ( <groupBy_columnName> [, <groupBy_columnName> [, … ] ] )
Parameters
Term | Definition |
---|---|
groupBy_columnName | The qualified name of an existing column or ROLLUPGROUP function to be used to create summary groups based on the values found in it. This parameter cannot be an expression. |
Return value
This function does not return a value. It marks a set of columns to be treated as a single group during subtotaling by ROLLUP or ROLLUPADDISSUBTOTAL.
Remarks
ROLLUPGROUP can only be used as a groupBy_columnName argument to ROLLUP, ROLLUPADDISSUBTOTAL, or ROLLUPISSUBTOTAL.
Example
See SUMMARIZE and SUMMARIZECOLUMNS.