Quick Calculation - Cumulative Value

Application Scenario 

Calculate the cumulative value of data in chart or table components.

For example, you may need to calculate the cumulative sales volume of all regions, as shown in the following figure.

Function Description 

Use the Cumulative Value or the Cumulative Value in Group functions in Quick Calculation.

Note:

This function cannot be used in detail tables.

Concept 

The cumulative value is the result of indicator values added up from top to bottom.

For example, the cumulative sales volume of regions and areas is shown in the following figure.

Calculating the Cumulative Value 

Use the Store sales statistics dataset in Public Data to create a group table, as shown in the following figure.

Choose Quick Calculation > Cumulative Value in the drop-down list of the Sales Volume field.

Calculating the Cumulative Value Using Functions 

Use the formula ACC_SUM(SUM_AGG(Sales Volume),0). For the usage of the ACC_SUM function, see ACC_SUM.

Concept 

The cumulative value in group is the result of indicator values in a group added up from top to bottom.

For example, the cumulative sales volume of areas in each region is shown in the following figure.

Calculating the Cumulative Value in Group 

Use the Store sales statistics dataset in Public Data to create a group table, as shown in the following figure.

Choose Quick Calculation > Cumulative Value in Group in the drop-down list of the Sales Volume field.

Calculating the Cumulative Value in Group Using Functions 

Use the formula ACC_SUM(SUM_AGG(Sales Volume),1). For the usage of the ACC_SUM function, see ACC_SUM.