A data function enables you to change the nature of the values displayed in a pivot table and enables you to decide the kind of value represented in a pivot table. When you use a data function, Interactive Reporting recalculates 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 data layout 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 the data layout, Interactive Reporting appends number to the name (for example, Amount_2, Amount_3). |
To apply a data function:
Select a fact in the data grid of the pivot table.
Select Pivot, then Data Function, and then Function.
The data values are recalculated and populate the row or column of the pivot table.
The table below lists the data functions available in the Pivot section.
Table 72. Pivot Data Functions
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. |