AGGREGATE
Creates an aggregated dynamic column. Aggregate allows you to group information from different tables. For example, you can group information about orders in a table that contains customer data in order to determine how many orders a customer has placed. Aggregation works with any table in the database as long as the tables are properly joined.
An Aggregate instruction must have the following syntax:
Syntax
AGGREGATE [Target tab  le][Target column][Source column][Function]([Filter])
Parameters
Target table
Defines the name of the target table, for example [SalesData].[MonthlySales]. The definition contains the database name, followed by the table name.
Target column
Defines the name of the target column. Do not use the following characters:
/ \ º ª - accents, dieresis,?, !, *, @, #, &, $, o, ñ
Source column
Defines the source column for the aggregation. The full definition includes, the database name, the table name, and the column name.
Function
Defines the aggregation function. The supported functions are shown in Table 5-2.
Table 5-2  
Filter
Use Domain definition to define a filter.
Description
Type text that describes the new column. You can type the text in the Description text box, or double-click to open a text editor and type the text there.
How to create an aggregating column
1  
2  
Figure 5-8  
3  
4  
5  
6  
7  
8  
9  
Figure 5-9  
10  

Additional Links:

Copyright Actuate Corporation 2013 BIRT Analytics 4.2