> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Monthly cumulative sales

> Calculate yearly cumulative sales in the source table.

Calculate yearly cumulative sales right in the source table.

![](https://img.alicdn.com/imgextra/i3/O1CN01u6UGeF1LVHc7ljLiW_!!6000000001304-2-tps-1337-702.png)

Steps:

1. Add an auto-sorting helper column.

![](https://img.alicdn.com/imgextra/i1/O1CN0131cWrp1Evf7CsrISF_!!6000000000414-2-tps-1332-687.png)

2. Add a lookup field for cumulative sales.

![](https://img.alicdn.com/imgextra/i2/O1CN01IduTLO1TM8dENqzk6_!!6000000002367-2-tps-782-804.png)

3. Once the result is computed, hide the helper column for a cleaner dashboard.

![](https://img.alicdn.com/imgextra/i3/O1CN01Vh1vnc1QhG34EMJoW_!!6000000002007-2-tps-1026-742.png)

[DingTalk AI Table — welcome! Get started with team collaboration on data: https://docs.dingtalk.io/table/template/911](https://docs.dingtalk.io/table/template/911 "DingTalk AI Table — welcome! Get started with team collaboration on data: https://docs.dingtalk.io/table/template/911")