Examples of totals

Example 1: In this example, the worksheet contains profit values for regions. You want to display a sub-total for each region, and a grand total for all regions.

Figure 14-4 Displaying a total on a table worksheet

Description of the illustration pivot_1d.gif

Key to figure:
a. A sub-total for each region (Total for Central: £94,651).
b. A grand total for all regions (Total for All Values: £320,301).

Example 2: In this example, a crosstab worksheet contains profit values for regions in different years. You want to display a profit total of all three years for each region.

Figure 14-5 Displaying a total on a crosstab worksheet

Description of the illustration tot_exp1.gif

Key to figure:
a. A total item named 'Sum' on rows, which calculates a total for each Region. For example, the total for the Central region is £234,498.

Example 3: In this example, the worksheet contains profit and sales values for each quarter in the Central region. You want to display a total profit figure and a total sales figure.

Figure 14-6 Displaying two totals on a crosstab worksheet

Description of the illustration tot_exp2.gif

Key to figure:
a. Two totals are selected for display, as follows: The Grand Total Rows Sum for Profit SUM total adds the Profit SUM column. The Grand Total Rows Sum for Sales SUM total adds the Sales SUM column.
b. The Grand Total Rows Sum for Profit SUM total on the crosstab worksheet.
c. The Grand Total Rows Sum for Sales SUM total on the crosstab worksheet.

Notice that the two totals are displayed on the same row. When a crosstab has multiple totals displayed, Discoverer automatically puts them on the same row.