小智常见报表示例 -- 层次坐标 -- 交叉表累计报表

[{"商品":"A产品","季度":1,"销售额":5890.56},{"商品":"A产品","季度":2,"销售额":4566.26},{"商品":"A产品","季度":3,"销售额":7861.56},{"商品":"A产品","季度":4,"销售额":5654.56},{"商品":"A产品","季度":1,"销售额":5820.96},{"商品":"A产品","季度":2,"销售额":5666.26},{"商品":"A产品","季度":3,"销售额":8661.56},{"商品":"A产品","季度":4,"销售额":5254.56},{"商品":"B产品","季度":1,"销售额":5890.56},{"商品":"B产品","季度":2,"销售额":4456.16},{"商品":"B产品","季度":3,"销售额":7561.56},{"商品":"B产品","季度":4,"销售额":3554.56},{"商品":"B产品","季度":1,"销售额":4620.96},{"商品":"B产品","季度":2,"销售额":5456.26},{"商品":"B产品","季度":3,"销售额":8891.56},{"商品":"B产品","季度":4,"销售额":5623},{"商品":"C产品","季度":1,"销售额":4600.78},{"商品":"C产品","季度":2,"销售额":5246},{"商品":"C产品","季度":3,"销售额":7761.56},{"商品":"C产品","季度":4,"销售额":8164},{"商品":"C产品","季度":1,"销售额":4645.56},{"商品":"C产品","季度":2,"销售额":6579},{"商品":"C产品","季度":3,"销售额":7591.56},{"商品":"C产品","季度":4,"销售额":7168},{"商品":"D产品","季度":1,"销售额":4678.56},{"商品":"D产品","季度":2,"销售额":6659},{"商品":"D产品","季度":3,"销售额":7567.56},{"商品":"D产品","季度":4,"销售额":7498},{"商品":"D产品","季度":1,"销售额":5246},{"商品":"D产品","季度":2,"销售额":4645},{"商品":"D产品","季度":3,"销售额":7561.8},{"商品":"D产品","季度":4,"销售额":7941},{"商品":"E产品","季度":1,"销售额":5890.56},{"商品":"E产品","季度":2,"销售额":4566.26},{"商品":"E产品","季度":3,"销售额":7861.56},{"商品":"E产品","季度":4,"销售额":5654.56},{"商品":"E产品","季度":1,"销售额":5820.96},{"商品":"E产品","季度":2,"销售额":5666.26},{"商品":"E产品","季度":3,"销售额":8661.56},{"商品":"E产品","季度":4,"销售额":5254.56},{"商品":"F产品","季度":1,"销售额":5890.56},{"商品":"F产品","季度":2,"销售额":4456.16},{"商品":"F产品","季度":3,"销售额":7561.56},{"商品":"F产品","季度":4,"销售额":3554.56},{"商品":"F产品","季度":1,"销售额":4620.96},{"商品":"F产品","季度":2,"销售额":5456.26},{"商品":"F产品","季度":3,"销售额":8891.56},{"商品":"F产品","季度":4,"销售额":5623},{"商品":"G产品","季度":1,"销售额":4600.78},{"商品":"G产品","季度":2,"销售额":5246},{"商品":"G产品","季度":3,"销售额":7761.56},{"商品":"G产品","季度":4,"销售额":8164},{"商品":"G产品","季度":1,"销售额":4645.56},{"商品":"G产品","季度":2,"销售额":6579},{"商品":"G产品","季度":3,"销售额":7591.56},{"商品":"G产品","季度":4,"销售额":7168},{"商品":"H产品","季度":1,"销售额":4678.56},{"商品":"H产品","季度":2,"销售额":6659},{"商品":"H产品","季度":3,"销售额":7567.56},{"商品":"H产品","季度":4,"销售额":7498},{"商品":"H产品","季度":1,"销售额":5246},{"商品":"H产品","季度":2,"销售额":4645},{"商品":"H产品","季度":3,"销售额":7561.8},{"商品":"H产品","季度":4,"销售额":7941}]

交叉表累计的公式说明：=B2+C2[;B1:-1]C2[;B1:-1]：表示上父格 B1横向扩展出来的上一格（上季度）的 C2 的值；B2+C2[;B1:-1]：表示当前季度的销售额加上上一季度累计销售额

https://www.yuque.com/attachments/yuque/0/2023/json/25420404/1686291216777-10fbf5d6-8e71-46a0-8e07-6ea8018fd598.json