How to Create an Aggregate Calculation

When a calculation uses an aggregate function, it's called an aggregate calculation. You create an aggregate calculation by defining a new calculated field as described in Ho w to Create a Ca lculated Field. The formula will contain one or more aggregate functions. You can easily pick an aggregate function from the Calculation dialog box by selecting Aggregate from the Functions menu as shown below.

These functions are identical to the predefined aggregate functions listed in Ag gre gations.


A graphic depicting the Calculation dialog box. Aggregate is selected in the Functions menu and the formula is an example of an aggregate calculation.

The aggregate calculation appears with the letters AGG in front of it when it is placed on a shelf.


A graphic depicting the AGG prefix on a calculation field placed on the Rows shelf. AGG signifies that it is an aggregate calculation.

When you create an aggregate calculation, no further aggregation of the calculation is possible. Therefore, the field’s context menu does not offer any aggregation choices. However, you can disaggregate the field. Refer to Agg regate Calculati ons in a Disaggregated State for more information.

The rules that apply to aggregate calculations are: