ROLLUPADDISSUBTOTAL
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
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
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru