Create Running Total Calculations for Tables

In your SAP Analytics Cloud table, you can create running total calculations (such as sum or average) using the Calculation Editor.

SAP Analytics Cloud already allows you to create running (accumulative) sums, counts, averages, and so on in tables, but those calculations are confined to the table they are created in. (For more information on custom running functions, see Create Custom Calculations Within Your Table.)

This feature lets you create running total calculations that can be used for other tables or charts in your story.

Restriction

This feature is only available in the optimized story experience.

How to Set Up Running Total Calculations

Remember

Dimensions that you use in your running calculations become required dimensions: if they aren't already in your table, you must add them.

Tip

If you rearrange or add dimensions, you'll change the results of the running calculations.

For example, your running sum shows the values for different sales managers. When you add a location dimension as the outer dimension, the running sum now restarts calculating when the location changes.

Use the Calculation Editor to set up your running totals.

Select a table.
In Builder, under Rows or Columns, select Add Dimensions and add the Account dimension or the Cross Calculations dimension.
Select either the Account or Cross Calculations dimension and then select Add Calculation.

Note
The option to create a new calculation may not appear if calculations are not possible for the model.
In the Calculation Editor under Type, select Running Total.
Enter a name for the running total.

Select a running total operation.

The following running total operations are supported:

Operation	Description
SUM	The sum of the account's values across all leaf members of the selected dimensions.
COUNT	The number of leaf members of the selected dimensions with values for a specific account, including null values. Empty values for this account are not counted. Note Although NULL and NO_DATA cells are visually identical, the application still distinguishes them in the backend. NULL cells are retrieved directly from the database, and can also be created using formulas. For example, IF( cost > 1000; NULL; 1). NO_DATA cells are empty cells that are used jointly with the unbooked mode or to create a cross-join of the rows and columns axis. The COUNT function only accounts for NULL cells in the aggregation, and discards the NO_DATA cells.
MIN	The smallest value across the selected dimensions.
MAX	The largest value across the selected dimensions.
AVERAGE	The average of the account's values across the selected dimensions, including null values. Note Although NULL and NO_DATA cells are visually identical, the application still distinguishes them in the backend. NULL cells are retrieved directly from the database, and can also be created using formulas. For example, IF( cost > 1000; NULL; 1). NO_DATA cells are empty cells that are used jointly with the unbooked mode or to create a cross-join of the rows and columns axis. The AVERAGE function only accounts for NULL cells in the aggregation, and discards the NO_DATA cells.

In the Account section, select an account from the list.
In the Running Total Dimensions section, select one or more dimensions to apply the running total calculation to. For example, if you select the Date and Product dimensions, values for each product at the smallest time granularity in the model will be calculated.

Use Add a Dimension to add additional dimensions.
Select OK.