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 column or side of the pivot table, and data label column heads are placed orthogonally.

  To add a cumulative total:

  1. Select a fact in the data grid of the pivot table.

  2. Select Pivot, then Add Cume.

    The Pivot Cume dialog box is displayed.

    Image shows the Pivot Cume dialog box

  3. If desired, type a new name for the pivot cume.

  4. Select the scope of the pivot cume from the drop-down list box.

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

  5. Click OK.

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