Rollup Types

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

Rollup Type	Description

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. 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 from the various fields selected, separated by a record delimiter. Learn more about List rollup type here
Maximum	Identifies the highest value in the selected field. User can add additional mappings to add relevant data along with the rollup field. Learn more about Advance Maximum rollup type here
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.

PWR Rollups