Calculating Cumulative Values Starting from a Specified Time

Preview

For example, calculate cumulative values of contract amounts starting from 2020/06/01.

Implementation Method

Filter out data after 2020/06/01.

After sorting Time of Contract in ascending order, calculate the cumulative contract amounts by adding a Summary Column and selecting Accumulation as Summary Mode.

Example data: Contract Information.xlsx

Creating a Subject

Create an analysis subject, and upload the downloaded data table Contract Information (default to selecting all fields).

Filtering out Data After 2020/06/01

Add the Filter step as shown in the following figure.

Calculating Cumulative Contract Amounts After a Specified Time

Add a Summary Column to accumulate Contract Amount in ascending order of Time of Contract.

Effect Display

After sorting the dates in ascending order, you can view the cumulative values.