By adding cumulative running totals to a pivot table, you can break totals by dimension to restart at each dimensional grouping in the report.
To add a cumulative calculation:
Select a fact item in the data grid of the Pivot.
Select Add Cume on the shortcut menu.
The Add Cume shortcut menu is displayed.
Select a scope from the Add Cume shortcut menu.
A new data values item named “Cume of X” is displayed across each row of the report. The new cume item maintains a cumulative running sum of the original data values item.
Note: | Cumulative totals are most effective when all dimensions are located on a row or column of the report, and data label column heads are placed orthogonally. |
To modify a cumulative calculation:
Select a column in which a cume has already been place in the pivot table’s data grid.
Select Modify Cume on the shortcut menu.
The Modify Cume submenu is displayed.
Select a scope from the Modify Cume shortcut menu.