> ### How to display aggregate data

> 1 | On the palette, under Quick Tools, drag an aggregation element and drop it in the header or footer row of a group or a table.

> 2 | On Aggregation Builder:

> 1 | In Column Binding Name, type a unique name. Remember, for each piece of calculated data to display in a report, there must be a column binding. The column binding name appears in the report design if you do not specify a value for the next option, Display Name.

> 2 | In Display Name, optionally type a name used only for display in the report design.

> 3 | In Data Type, select the type of the aggregate value.

> 4 | In Function, select an aggregate function.

> 5 | In Expression, do one of the following:

> o | Select a data set field whose values to perform the aggregate calculation.

> o | If performing an aggregate calculation on values other than values in a data set field, type an expression. You can open the expression builder to get help constructing an expression.

> 6 | In Filter Condition, specify the filter condition to use to determine which rows are factored in the aggregate calculation.

> 7 | In Aggregate On, select either table or a specific group:

> o | Select table to perform the aggregate calculation over all the rows in the table.

> o | Select a specific group to perform the aggregate calculation over all the rows in the selected group.

> Figure 9‑1 shows an example of a complete definition for an aggregation element. In the example, the element returns the number of rows in the table, where the extended price of the product is greater than $5,000.00.

> Figure 9‑1 | Aggregation Builder displaying values for getting the count of products in the table

> 8 | Choose OK.

> In the report design, the aggregation element displays the sigma symbol followed by the column binding name, as shown in the following example:
> [Total_Products]

> 3 | Preview the report to verify the results of the aggregation.

(c) Copyright Actuate Corporation 2009