How to display aggregate values in a cross tab

1	To specify display properties for the aggregate values in the cross tab, in Crosstab Builder, choose Crosstab Builder—Format, as shown in Figure 7-11.

Figure 7-11

Specifying display options for the aggregate values

2	In Grand Totals, do the following:

Select Show Grand Totals for Rows to display grand totals for each row.

Select Show Grand Totals for Columns to display grand totals for each column.

3	You can display subtotals for multilevel dimensions used in rows or columns. Because the example in Figure 7-10 does not contain multilevel dimensions, the Sub Totals section is not highlighted. In Sub Totals, if highlighted, do the following:

Select Show Sub Totals for Rows.

Select Show Sub Totals for Columns.

4	In Page Break, as shown in Figure 7-11, select Enable Page Break to specify pagination properties for the cross tab, and do the following:

In Row Interval, type a value, such as 40.

In Column Interval, type a value, such as 10.

Choose OK. Sample data appears in the cross tab, displaying grand totals for rows and columns, as shown in Figure 7-12.

Figure 7-12

Displaying grand totals for rows and columns in a cross tab

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

BIRT iHub 2