分组排序报表
概述
分组排序报表：按分组的某个字段进行排序的报表。
应用场景
如下图所示，简单展示数据
Preview
示例说明
数据准备
在数据面板中添加数据集，可选择Json数据集和API服务数据集。Json数据集输入如下图所示：
[{"商品":"A产品","季度":1,"销售额":5890.56},{"商品":"A产品","季度":2,"销售额":4566.26},{"商品":"A产品","季度":3,"销售额":7861.56},{"商品":"A产品","季度":4,"销售额":5654.56},{"商品":"B产品","季度":1,"销售额":5890.56},{"商品":"B产品","季度":2,"销售额":4456.16},{"商品":"B产品","季度":3,"销售额":7561.56},{"商品":"B产品","季度":4,"销售额":3554.56},{"商品":"C产品","季度":1,"销售额":4600.78},{"商品":"C产品","季度":2,"销售额":5246},{"商品":"C产品","季度":3,"销售额":7761.56},{"商品":"C产品","季度":4,"销售额":8164},{"商品":"D产品","季度":1,"销售额":4678.56},{"商品":"D产品","季度":2,"销售额":6659},{"商品":"D产品","季度":3,"销售额":7567.56},{"商品":"D产品","季度":4,"销售额":7498}]
报表设计
将数据字段拖入A2、B2、C2单元格，并设置成向下扩展。
将A2、B2单元格设置为分组。将C2单元格设置成汇总。
在D2单元格输入公式=COUNT(C2[!0]{A2 = $A2 && C2 > $C2}) + 1
选中A1-D2单元格，点击上方工具栏-添加分组。
如下图所示
Preview
效果预览
Preview