Data Analysis and Reporting with Intelligence Clients

Using Data Functions

A Data Function enables you to change the nature of the values displayed in a pivot table and allows you to decide the kind of value represented in a pivot table. When you use a data function, the selected values according to the function applied to the underlying data values (which are originally from the Results section).

Data functions are particularly useful if you want to display different types of values side by side. If you add the same fact (such as Amount Sales) to the Outliner several times, you can apply a different data function to the very same dimension.

For example, you can show the total sale, average sale, and maximum sale of each product by quarter. Each of these computed items uses Amount Sales as its underlying value. They only differ in the data function used to calculate them.

	Note   When you add multiple instances of a Request item to the Facts pane in Outliner, Intelligence Clients appends number to the name (for example, Amount_2, Amount_3).

To apply a data function:

Select a fact in the pivot table’s data grid.
Choose PivotData FunctionFunction.

The data values are recalculated and populate the row or column of the pivot table.

	Tip   You can change the label of the new column or row if you wish.

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

Data Function Definitions 

---

Function	Description
Sum	Returns sum of all values. This is the default setting.
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 pivot table.
Increase	Returns the incremental difference between the final two instances of a total column or row. Apply only at the innermost dimensional level of a pivot table.
% Increase	Returns the percent difference between the final two instances of a total column or total row. Apply only at the innermost dimensional level of a pivot table.
Non-Null Average	Returns average of values; null values excluded.
Null Count	Returns number of null values.
Non-Null Count	Returns number of values; null values excluded.

---

	Note   Null values are empty values for which no data exists. Null values are not equal to zero.