Data Analysis and Reporting with Intelligence Clients

Adding Cumulative Totals

Add cumulative totals to break totals by dimension and restart them at each dimensional grouping in a pivot table. Cumes work best when all dimensions are located at the top or side of the pivot table, and data label column heads are placed orthogonally.

To add a cumulative total:

Select a fact in the pivot table’s data grid.
Choose PivotAdd Cume.

The Pivot Cume dialog box appears.



If desired, type a new name for the pivot cume.
Select the scope of the pivot cume from the drop-down list.

The Scope drop-down list includes all of the dimensions in the pivot table. The default scope is the lowest level dimension that appears in the pivot table.

Click OK.

A new fact column is added that maintains a cumulative running total of the original fact by the dimension (scope) specified.