Working with a measure column
Every summary table must contain at least one measure column to display aggregate data. The developer typically sets default aggregation functions for each measure column when creating the information object or data object. You can modify the default aggregate function and add additional aggregate functions to data in measure columns.
Inserting a measure column
A measure column is typically inserted to the right of dimension and attribute columns in a summary table. When you insert a measure column in a summary table, aggregate data is displayed based on the default aggregation function set by developer at the time of creating the data set. You can modify the aggregate function and add additional aggregation functions using BIRT Studio.
Modifying a measure column
You can perform the following actions on a measure column:
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
To modify a measure column, select the column, and choose an option from the context menu, as shown in Figure 6-18.
Figure 6-18  
Adding an aggregate calculation
You can apply multiple aggregate functions to a single measure column in a summary table. To add an aggregate function, complete the following steps:
1  
2  
In Select Subtotal Function, as shown in Figure 6-19, select an aggregate function from the drop-down list.
3  
Figure 6-19  
Moving a measure column
When you move a measure column in a summary table, you can move it among other measure columns. Measure columns always appear to the right of dimension and attribute columns in a report design.
Deleting a measure column
To delete a measure column, select the column, and choose Delete.

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2