交叉报表–交叉表累计
概述
交叉表累计:在交叉表中统计当前累计值。
应用场景
如下图所示,简单展示数据
示例说明
数据准备
在数据面板中添加数据集,可选择Json数据集和Http接口数据集,Json数据如下图所示:
[{"商品":"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}]
报表设计
将B1-C1合并单元格。
将数据字段拖入A2、B1、B2单元格。
将A2和B1设置为分组,B2设置为汇总。
将A2设置为向下扩展,B1设置为向右扩展,B2设置为双向扩展。
选中C2单元格输入公式=B2+C2[;B1:-1]
选中A1-C2,点击上方工具栏-添加分组。
如下图所示
效果预览
交叉表累计.json
https://www.yuque.com/attachments/yuque/0/2023/json/25420404/1700534097215-83c5d71d-bf5e-4957-9bde-ea4190d8dfc1.json
参考文档
- 小智报表样例源码下载
- https://gitee.com/tizdata_admin/vue-xzreport-example.git
- 小智报表demo体验
- https://xzdemo.tizdata.com/#/imbedShow/reportExample
- 丰富的报表模板示例
- 小智报表在线试用
- https://xzreport.com
- 小智报表js sdk下载
- https://tizdata.com/xzdownload/
- 开发使用文档
- https://doc.tizdata.com/xiaozhi/650