ROLLUPADDISSUBTOTAL
Modifies the behavior of the SUMMARIZECOLUMNS function by adding rollup/subtotal rows to the result based on the groupBy_columnName columns. This function can only be used within a SUMMARIZECOLUMNS expression.
Syntax
ROLLUPADDISSUBTOTAL ( [<grandtotalFilter>], <groupBy_columnName>, <name> [, [<groupLevelFilter>] [, <groupBy_columnName>, <name> [, [<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. |
| name | 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
The function does not return a value.
Remarks
None
Example
See SUMMARIZECOLUMNS.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for