In this section, by clicking on Add Rollup button users can create as many rollup actions 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. user can add additional mappings to help to better understand the maximum value in relation to other data. Learn more about Advance Maximum rollup type here |
Minimum | Identifies the lowest value in the selected field. Learn more about Advance Maximum rollup type here |
Sum | Adds up the values of the selected field. |