Previous Next

Task 6:  Add grand totals

Each number displayed in the cross tab represents the sales total of a particular product for a particular state. In this procedure, you add grand totals to display the total sales of all products for each state, the total sales of each product, and the total of all sales across products and states.

1  
2  
3  
4  
5  
In Grand Total, shown in Figure 16-11, use the default values, then choose OK.

Figure 16-11 Creating grand totals in the cross-tab row area

Figure 16-11  Creating grand totals in the cross-tab row area
A new row is added to the bottom of the cross tab, as shown in Figure 16-12. In this row is a label that displays Grand Total and a data element that displays [EXTENDED_PRICE].

Figure 16-12 Cross tab including a new row to display grand totals

Figure 16-12  Cross tab including a new row to display grand totals
6  
7  
8  

Figure 16-13 Cross tab with a new column to display grand totals

Figure 16-13  Cross tab with a new column to display grand totals
9  

(c) Copyright Actuate Corporation 2013