交叉表纵向合计

交叉报表–交叉表纵向合计

概述

交叉表纵向合计：交叉表加上纵向求和功能。

应用场景

如下图所示，简单展示数据

示例说明

数据准备

在数据面板中添加数据集，可选择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}]

报表设计

将数据字段拖入A2、B1、B2单元格。
在B3单元格输入公式=sum(B2)。
选中A1-B3单元格，点击上方工具栏-添加分组。
将A2单元格设置为分组以及向下扩展。
将B1单元格设置为分组以及向右扩展。
将B2单元格设置为汇总以及双向扩展。
点击上方工具栏此按钮设置交叉表表头，用 | 分隔。

效果预览

交叉表纵向合计.json

https://www.yuque.com/attachments/yuque/0/2023/json/25420404/1700472135463-8eea9584-e6be-4f65-906c-1ab3321caf7a.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