In this section, by clicking on Add Rollup button users can create as many rollups 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 all the values in the selected field. | ||
Concat | Combines the values of the selected field into a single, concatenated string.
| ||
Count | Calculates the total number of records. | ||
Count Distinct | Counts the number of unique records. | ||
List | Generates a list of all values in from the various fields selected field, separated by a record delimiter.
| ||
Maximum | Identifies the highest value in the selected field. user User can add additional mappings to help to better understand the maximum value in relation to other dataadd relevant data along with the rollup field.
| ||
Minimum | Identifies the lowest value in the selected field. User can add additional mappings to add relevant data along with the rollup field.
| ||
Sum | Adds up all the values of the selected field. |
...