分组报表–分组单元格合并报表
概述
分组单元格合并报表:占列式分组其分组头不占据单独的显示行,也就是表格分组单元格合并。
应用场景
如下图所示,简单展示数据
示例说明
数据准备
在数据面板中添加数据集,可选择Json数据集和Http接口数据集,Json数据如下图所示:
[{"商品":" A产品","季度":1,"年份":2020,"销售额":1},{"商品":" A产品","季度":2,"年份":2020,"销售额":2},{"商品":" A产品","季度":3,"年份":2020,"销售额":1},{"商品":" A产品","季度":4,"年份":2020,"销售额":1},{"商品":" A产品","季度":1,"年份":2021,"销售额":2},{"商品":" A产品","季度":2,"年份":2021,"销售额":2},{"商品":" A产品","季度":3,"年份":2021,"销售额":1},{"商品":" A产品","季度":4,"年份":2021,"销售额":2},{"商品":" B产品","季度":1,"年份":2020,"销售额":3},{"商品":" B产品","季度":2,"年份":2020,"销售额":1},{"商品":" B产品","季度":3,"年份":2020,"销售额":2},{"商品":" B产品","季度":4,"年份":2020,"销售额":1},{"商品":" B产品","季度":1,"年份":2021,"销售额":2},{"商品":" B产品","季度":2,"年份":2021,"销售额":1},{"商品":" B产品","季度":3,"年份":2021,"销售额":3},{"商品":" B产品","季度":4,"年份":2021,"销售额":2}]
报表设计
将数据字段拖入A2、B2、C2、D2单元格,并设置为向下扩展。
将A2、B2、C2单元格设置为分组,将D2单元格设置为汇总。
选中A1-D2单元格,点击上方工具栏-添加分组。
如下图所示
效果预览
分组单元格合并.json
https://www.yuque.com/attachments/yuque/0/2023/json/25420404/1700466805116-68444d21-12f3-4ce0-b965-bfa765bec1a0.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