基本分组报表
概述
基础分组报表：一个最基本的分组报表，定义一个分组，并定义分组的“依据字段”属性。
应用场景
如下图所示，简单展示数据
Preview
示例说明
数据准备
在数据面板中添加数据集，可选择Json数据集和API服务数据集。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}]
报表设计
合并A2-A3单元格。
将数据字段拖入A2、B2、C2单元格，并设置成向下扩展。
A2(test.商品)和B2(test.季度)设置成分组，C2(test.销售额)设置成汇总。
在C3单元格输入公式=SUM(C2)
选中A1-C3单元格，点击上方工具栏-添加分组；选中B2-C3单元格，再次点击上方工具栏-添加分组。
如下图所示
Preview
效果预览
Preview