How to lay out data in a cross tab

1	Select the cross tab template, then select the cube to use. Crosstab Builder—Data appears, as shown in Figure 7-10.

Figure 7-10

Selecting data to display in the cross tab

2	In Crosstab Builder—Data, in Dimensions, in Available Data, select a grouped data field. To select multiple data fields press Ctrl as you select each field.

3	Choose the right arrow next to Row to set the selected field as a row, or choose the right arrow next to Column to set the selected field as a column. The example, as shown in Figure 7-10, specifies State as a row, and Product Line as a column.

4	In Measures, in Available Data, select a data field to aggregate, then choose the right arrow to set the selected field as a summary field. The example in Figure 7-10 sets the Extended Price field as the summary field.

Choose OK. The selected fields appear in a cross tab in BIRT Studio.

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

BIRT iHub 2