> #### How to display subtotals and grand totals

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

> 1 | Select the cross tab.

> 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‑26 shows the Row Area tab selected.

> Figure 17‑26 | Adding a subtotal to a cross tab’s row area

> 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 | On Sub Total or Grand Total:

> 1 | In Aggregate On, select the dimension or dimension level whose total to display.

> 2 | In Data Field, select the field whose values to aggregate.

> 3 | In Function, select an aggregate function.

> Figure 17‑27 shows an example of displaying subtotals for the year dimension.

> Figure 17‑27 | Specifying a subtotal in a cross tab

> 4 | Choose OK.

> 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‑27, a label in the new row displays [year]Total, and a data element displays [EXTENDED_PRICE], as shown in Figure 17‑28.

> Figure 17‑28 | Elements that display year subtotals in a cross tab

(c) Copyright Actuate Corporation 2009