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. |
Sum
Adds up the values of the selected field.
List | Generates a list of all values from the various fields selected, separated by a record delimiter.
| ||
Maximum | Identifies the highest value in the selected field. User can add additional mappings to add relevant data along with the rollup field.
| ||
Minimum | Identifies the lowest value in the selected field. |
Average
User can add additional mappings to add relevant data along with the rollup field.
| ||
Sum | Adds up all the values of the selected field. |