What are totals?

Totals are worksheet items that enable you to quickly and easily summarize rows and columns. For example, to calculate the sum of a column of profit figures, or to calculate the average of a row of sales figures. You can then use the totals to analyze the worksheet data.

Figure 14-1 A Discoverer worksheet with totals

Description of the illustration tot_exp.gif

Key to figure:
a. Sub-totals defined on Profit SUM for each region.
b. A grand total defined on Profit SUM for all regions.

You use Discoverer totals to calculate:

• the result of applying a calculation to totals (the SUM - for more information, see "When to use SUM instead of Cell SUM")

• the result of adding values (the Cell SUM - for more information, see "When to use Cell SUM instead of SUM")

• the number of values (the Count)

• the lowest of the values (the Minimum)

• the highest of the values (the Maximum)

• the square root of the variance (the Standard Deviation)

• the amount of variance in a set of values (the Variance)

When a worksheet contains totals, you can:

• display the totals (or turn the totals on)

• hide the totals (or turn the totals off)