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.
