跳到主要内容

多级分组单元格合并报表

概述​

多级分组单元格合并报表：演示多级分组占列式分组报表。

应用场景​

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

image
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-A4单元格、B2-B3单元格、B4-C4单元格、A5-C5单元格。
将数据字段拖入A2、B2、C2、D2单元格，并设置成向下扩展。
A2(test.商品)、B2(test.年份)和C2(test.季度)设置成分组，D2(test.销售额)设置成汇总。
在D3、D4、D5单元格输入公式=sum(D2)
选中A1-D5单元格，点击上方工具栏-添加分组；选中B1-D4单元格，点击上方工具栏-添加分组；选中C1-D3单元格，点击上方工具栏-添加分组。
如下图所示

image
Preview

效果预览​

多级分组单元格合并.json

image
Preview