When you add an aggregator, you can perform aggregate calculations on groups of columns or all columns. When you group by columns, you can apply the aggregate conditions and rules to multiple columns. You can include filters, rules, conditional clauses, and nested expressions in an aggregator. You can also add different aggregators to multiple columns.

You can add, edit, or delete an aggregator. You can also preview data in an aggregator.

You can add the following types of aggregators:

Simple aggregator

Aggregates data by applying conditions and rules to multiple columns. You can add lookup, rule, and source columns to the conditions in a simple aggregator.

Advanced aggregator

Aggregates data by applying aggregate functions and expressions to multiple columns. You can add lookup, rule, and source columns to the expression in a condition in an advanced aggregator.