Running Sums for Measure Columns in Pivot Tables

In a pivot table, you can display numeric measures as running sums, where each consecutive cell for the measure displays the total of all previous cells for that measure. This option is a display feature only that has no effect on actual pivot table results.

Typically, running sums are displayed for duplicated attribute columns or for measure columns for which the option to show data as a percentage of the column has been selected, with the last value being 100 percent. Running sums apply to all totals. The running sum for each level of detail is computed separately.

Column headings are not affected when the running sum option is selected. You can format the column heading if you want it to indicate that the running sum option is in effect.

The following usage rules are in effect for running sums:

• A running sum is incompatible with the SQL RSUM function (the effect would be a running sum of the running sum).

• All running sums are reset with each new section. A running sum does not reset at a break within a section or continued across sections.

• If a measure does not display in a single column or in a single row, then the measure is summed left to right and then top to bottom. (The lower right cell contains the grand total.) A running sum does not reset with each row or column.

• You cannot specify rolling minimums, maximums, and averages in the Layout pane. You can include these if administrators create formulas for them in the metadata repository.