Data functions

The Chart section provides the ability to change the datatype used to aggregate the fact items in the section. The default is set to Sum and can be changed to another configuration. Other functions include Average, Count, Count Distinct, Maximum, Minimum, and Percent of Grand. The data function of a fact item can easily be adjusted by one of the following methods:

Right-click method

Chart menu method

Highlight the fact item to modify in the Chart or Data Layout.

Right-click and highlight the Data Function menu item.

Select the Data Function of interest.

Highlight the fact item to modify in the Chart or Data Layout.

Open the Chart menu and highlight the Data Function menu item.

Select the Data Function of interest.

Get The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.