Previous Next

How to display subtotals and grand totals

This procedure assumes that you have already inserted dimensions and measures in the cross tab.

1
2
In Property Editor, choose the Row Area tab or the Column Area tab to add a subtotal or grand total in the row area and column area, respectively. Figure 17‑24 shows the Row Area tab selected.

Figure 17‑24
3
To create a subtotal, select Sub Totals, then choose Add. To create a grand total, select Grand Totals, then choose Add. A cross tab can always include grand totals. If, however, a row or column area consists of only one dimension, there can be no subtotals. The Add button is disabled if you cannot create a subtotal.
4
1
2
3
Figure 17‑25 shows an example of displaying subtotals for the year dimension.

Figure 17‑25
4
A new row or column is added to the cross tab, and it contains a label and a data element. For the subtotal example shown in Figure 17‑25, a label in the new row displays [year]Total, and a data element displays [EXTENDED_PRICE], as shown in Figure 17‑26.

Figure 17‑26

(c) Copyright Actuate Corporation 2009