Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure 
Visual calculation
Pairs rollup groups with the column added by ROLLUPADDISSUBTOTAL. This function can only be used within an ADDMISSINGITEMS expression.
Syntax
ROLLUPISSUBTOTAL ( [<grandTotalFilter>], <groupBy_columnName>, <isSubtotal_columnName> [, [<groupLevelFilter>] [, <groupBy_columnName>, <isSubtotal_columnName> [, [<groupLevelFilter>] [, … ] ] ] ] )
Parameters
| Term | Definition |
|---|---|
grandTotalFilter |
(Optional) Filter to be applied to the grandtotal level. |
groupBy_columnName |
Name of an existing column used to create summary groups based on the values found in it. Cannot be an expression. |
| isSubtotal_columnName | Name of an ISSUBTOTAL column. The values of the column are calculated using the ISSUBTOTAL function. |
groupLevelFilter |
(Optional) Filter to be applied to the current level. |
Return value
None
Remarks
This function can only be used within an ADDMISSINGITEMS expression.