> ## 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.

# 月份销售累计求和

> 在原数据表里计算当年的销售累计求和

在原数据表里计算当年的销售累计求和

<img src="https://mintcdn.com/dingtalk-8c0f98e2/TruNvZgRYJbb0Amj/zh/aitable/formulas/function-practices/monthly-sales-cumulative/images/image_kxRWc9Skn6.png?fit=max&auto=format&n=TruNvZgRYJbb0Amj&q=85&s=a59df33c9650c94704155a6fb45440a3" alt="" width="1584" height="908" data-path="zh/aitable/formulas/function-practices/monthly-sales-cumulative/images/image_kxRWc9Skn6.png" />

配置操作：

1、新建1个自动排序的辅助列字段

<img src="https://mintcdn.com/dingtalk-8c0f98e2/TruNvZgRYJbb0Amj/zh/aitable/formulas/function-practices/monthly-sales-cumulative/images/image_oM7ZGIgzax.png?fit=max&auto=format&n=TruNvZgRYJbb0Amj&q=85&s=d7992385e02ba0bbf0cad8643c9fb8eb" alt="" width="1558" height="910" data-path="zh/aitable/formulas/function-practices/monthly-sales-cumulative/images/image_oM7ZGIgzax.png" />

2、配置一个累计销量的查找引用字段

<img src="https://mintcdn.com/dingtalk-8c0f98e2/TruNvZgRYJbb0Amj/zh/aitable/formulas/function-practices/monthly-sales-cumulative/images/image_ZYuVC83wgv.png?fit=max&auto=format&n=TruNvZgRYJbb0Amj&q=85&s=e48268cfa01c9fb53fe44dbff81a2ada" alt="" width="1070" height="1208" data-path="zh/aitable/formulas/function-practices/monthly-sales-cumulative/images/image_ZYuVC83wgv.png" />

3、计算出结果后，可以将辅助列隐藏，让看板更可视化

<img src="https://mintcdn.com/dingtalk-8c0f98e2/TruNvZgRYJbb0Amj/zh/aitable/formulas/function-practices/monthly-sales-cumulative/images/image_EAVMU6bFbA.png?fit=max&auto=format&n=TruNvZgRYJbb0Amj&q=85&s=98310fd1883c542e682bf649637b5a62" alt="" width="1128" height="996" data-path="zh/aitable/formulas/function-practices/monthly-sales-cumulative/images/image_EAVMU6bFbA.png" />

[ DingTalk多维表 欢迎来到DingTalk多维表，开启业务数字化的团队协作！ https://docs.dingtalk.io/table/template/911](https://docs.dingtalk.io/table/template/911 " DingTalk多维表 欢迎来到DingTalk多维表，开启业务数字化的团队协作！ https://docs.dingtalk.io/table/template/911")