Aggregating values
Video tutorial
Aggregates supports aggregating, or grouping, values in a data field. You can aggregate values from one field in any table. For example, create an aggregate using the Count function in the Order field of the Customer table to see how many orders each customer placed.
How to create an aggregate
1  
2  
Figure 3-6  
3  
4  
5  
*
*
*
*
*
*
*
*
*
*
*
6  
7  
For example, to aggregate orders placed by Customers in London, select Count in Function, drag Order No. from Customers and drop Order No. in the Origin column.
How to aggregate totals for a specific group
1  
2  
3  
4  
5  
Figure 3-7  
6  
Figure 3-8  
7  
8  
Figure 3-9  
Video tutorial
Create an aggregate field

Additional Links:

Copyright Actuate Corporation 2013 BIRT Analytics 4.2