Previous Next

Presenting Data in a Cross Tab : Tutorial 6: Creating a cross tab : Task 5: Add a cross tab to the report

Task 5:

You add a cross tab to the report, then you insert data from the cube into the row, column, and detail areas of the cross tab.

1

Figure 17-8 Cross tab inserted in the report

Figure 17-8
The cross tab displays instructions for adding data to specific areas in the cross tab.
2
Choose Data Explorer. Under the first group in the Sales cube, drag STATE and drop it in the cross-tab area that displays Drop data field(s) to define rows here, as shown in Figure 17‑9.

Figure 17-9 Inserting STATE data in the cross tab

Figure 17-9
3
From the Sales cube, under Group1, drag PRODUCTLINE and drop it in the cross-tab area that displays Drop data field(s) to define columns here.
4
From the Sales cube, under Summary Field, drag EXTENDED_PRICE and drop it in the cross-tab area that displays Drop data field(s) to be summarized here.
The cross tab should look like the one shown in Figure 17‑10.

Figure 17-10 Cross tab design

Figure 17-10
5
Choose Preview to preview the cross tab output. Figure 17‑11 shows a portion of the data that the cross tab displays.

Figure 17-11 Preview of the cross tab data

Figure 17-11
The row headings display the states, the column headings display product lines, and the cells display the sales totals. The first cell displays 458563.64, which is the sales total of classic cars sold in California.

(c) Copyright Actuate Corporation 2008