Adding Data Functions

Column or row totals added to the OLAPQuery section are aggregates and can be recalculated using data functions. When applied to totals, data functions apply the calculation to surface values.

When applied to surface values, data functions recalculate the values in the visible cells or surface of the OLAPQuery section. For example, you can show the total sale, average sale, and maximum sale of each product by quarter. Each of these dimensions is based on the same value. They only differ in the data function that is applied.

  To apply a total function:

  1. Select the dimension handle for a particular measure.

  2. Click Grand Total icon on the Standard toolbar to calculate the total.

  3. Select a column of a particular measure.

  4. Choose OLAP, then Data Function and then select a function.

    The following table lists the data functions available in the OLAPQuery section.

    Table 46. OLAPQuery Data Functions

    Data Function

    Description

    Sum

    Returns sum of all values. This is the default function in all report sections.

    Average

    Returns average of all values.

    Count

    Returns number of values.

    Maximum

    Returns highest value.

    Minimum

    Returns lowest value.

    % of Column

    Returns surface values as a percentage of their respective column item.

    % of Row

    Returns surface values as a percentage of their respective row item.

    % of Grand

    Returns surface values as a percentage of all like values in the report.