Totals and computed items

The Pivot section provides the ability to add Totals and Computed Items to perform computations directly in the pivot. Pivots provide a very easy method of adding computations at any breakout of data. The following example shows a Pivot configured with sales by product category and region across fiscal years:

Totals and computed items

Totals

Totals can be added at any level of detail across the Row or Column labels to perform break and grand totals on a dataset. Totals are easily added to a pivot by following these two methods:

Right-click method

Pivot menu method

Highlight the Row or Label column in the Pivot

Highlight the Row or Label column ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.