Previous Next

Task 5:  Add a cross tab to the report

In this procedure, you add a cross tab to the report, then you insert data from the cube into the cross tab.

1  
2  
Drop data field(s) to define rows here
Figure 16-8 shows inserting STATE in this location.

Figure 16-8 Inserting STATE data in the cross tab

Figure 16-8  Inserting STATE data in the cross tab
3  
Drop data field(s) to define columns here
4  
Drop data field(s) to be summarized here
5  
The cross tab should look like the one shown in Figure 16-9.

Figure 16-9 Cross tab design

Figure 16-9  Cross tab design
6  
Choose Preview. Figure 16-10 shows a portion of the data that the cross tab displays.

Figure 16-10 Preview of the cross tab data

Figure 16-10  Preview of the cross tab data
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 2013