In this section, users can create as many rollups as they want within the hierarchy after it's created.
Rollup type specifies the aggregate operators you can use when creating a rollup. PWR Rollup offers various aggregate operators:
Rollup Type | Description |
|---|---|
Average | Calculates the average of the values in the selected field. |
Concat | Combines the values of the selected field into a single, concatenated string. Learn more about Concat rollup type here |
Count | Calculates the total number of records. |
Count Distinct | Counts the number of unique records. |
List | Generates a list of all values in the selected field, separated by a delimiter. Learn more about List rollup type here |
Maximum | Identifies the highest value in the selected field. |
Minimum | Identifies the lowest value in the selected field. |
Sum | Adds up the values of the selected field. |