OLAP Data Functions

Column or row totals added to your OLAPQuery are aggregates (literally, totals of totals), and can be recalculated using data functions. When applied to totals, data functions apply to the calculation to “surface” values.

When applied to surface values, data functions recalculate the values in the visible cells or “surface” of the OLAPQuery. 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.

Table 47. OLAP Data Functions

Data Function	Returns the:
Sum	Sum of all values
Average	Average of all values
Count	Number of values
Maximum	Highest value
Minimum	Lowest value
% of Row	Surface values as a percentage of their respective row item
% of Column	Surface values as a percentage of their respective column item
% of Grand	Surface values as a percentage of all like values in the report

To apply a data function:

Select a row or column of facts (such as Amount).
Select Data Function.
A list of available data functions is displayed.
Optional: You can also select the item or column and choose Actions, then Data Function.
Select the function.
Each column is recalculated according to the data function applied to the underlying value.