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:

Insert a new computed column.

Specify conditional formatting rules.

Use the following numeric and non-numeric subtotal functions to modify aggregate data:

First

Last

Count value

Max

Min

Sum

Average

Median

Standard deviation

Variance

Mode

Create a hyperlink.

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

Modifying a measure column

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	In Available Data, select the measure column, and choose Insert.

2	In Select Subtotal Function, as shown in Figure 6-19, select an aggregate function from the drop-down list.

3	Choose OK. The measure column you selected appears in the report design displaying aggregate values for the new aggregate function you defined.

Figure 6-19

Adding an aggregate function

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.

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2