Analyzing Pivot Data

Data functions in the Pivot section are particularly useful if you want your report to display different types of values. Data functions summarize groups of database records and replace the original values with new summary data.

For example, in the Pivot section, you can show either the total sale, average sale, or the maximum sale of each product by quarter. Each of these dimensions is based on the same underlying values. They differ only in the data function that is applied.

Table 45. Pivot Data Functions

Data Function	Returns the:
Sum	Sum of all underlying values.
Average	Average of all underlying values.
Count	Number of underlying values.
Count Distinct	Number of distinct values in a column.
Null Count	Number of nulls among underlying values.
Non-Null Count	Number of underlying values; null values are excluded.
Maximum	Highest of underlying values.
Minimum	Lowest of underlying values
% of Row	Sum of underlying values as a percentage of their respective surface row.
% of Column	Sum of underlying values as a percentage of their respective surface column.
% of Grand	Sum of underlying values as a percentage of all surface values in the report.

To apply a data function:

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