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