Brio Software
Technical Publications
Home Previous Next Index Glossary
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:

  1. Select a fact in the pivot table’s data grid.
  2. Choose Pivot then Data Function then Function.
  3. 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.


Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.