分组单元格合并报表
概述
分组单元格合并报表：占列式分组其分组头不占据单独的显示行，也就是表格分组单元格合并。
应用场景
如下图所示，简单展示数据
Preview
示例说明
数据准备
在数据面板中添加数据集，可选择Json数据集和API服务数据集。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单元格，点击上方工具栏-添加分组。
如下图所示
Preview
效果预览
Preview