Task 6:Each number that is 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.
2 Select the cross tab by clicking on the tab in the lower left corner of the cross tab. Make sure you select the entire cross tab, not just a part of it. Property Editor displays the properties of the cross tab, as shown in Figure 17‑12.
Figure 17-12 Property Editor displays the general properties of the selected cross tab
5 On Grand Total, shown in Figure 17‑13, use the default values, then choose OK.
Figure 17-13 A new row is added to the cross tab, as shown in Figure 17‑14. In this row is a label that displays Grand Total and a data element that displays[EXTENDED_PRICE].
Figure 17-14 Cross tab including a new row to display grand totals
Figure 17-15
(c) Copyright Actuate Corporation 2008 |