Create Running Total Calculations for Charts

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

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 chart, 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 chart.
In Builder, choose Add Account Calculations Add Calculation.
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.