Introduction
In SAP Analytics Cloud chart, you can create running total calculations using the Calculation Editor. This feature lets you create running total calculations which can be used for other tables or charts in a story.
Note
-
This feature is only available in the optimized story experience.
Set Up Running Total Calculations:
The dimensions that you use in the running calculations become required dimensions. If the relevant dimensions are not added in the chart, then you must add them. If you rearrange or add dimensions, the results of the running calculations will change as well.
Procedure:
1
Select a chart and in the Builder panel, choose Add Account -> Calculations -> Add Calculation.
2
In the Calculation Editor under Type, select Running Total.
3
Enter a name and description (optional) for the running total.
Configure the Table Using the Builder Panel
4
Under Operation, select a running total operation. There are 5 options to choose from:
- SUM: Sum of Account values across all leaf members of the selected dimension.
- 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. Only NULL cells are counted whereas blank cells are rejected from the count.
- 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. Only NULL cells are counted whereas blank cells are rejected from the count.
5
In the Account section, select an account from the list.
6
In the Running Total Dimensions section, select one or more dimensions to apply the running total calculation to. Click on OK.
Note
-
In this case, for the Date and Product dimensions, values for each Product at the smallest time granularity in the model will be calculated.
-
You can click on the Add a Dimension to add additional dimensions.
