## 一、定义: 仅限于组合动态列分组中 用于动态属性的纵向小计,且纵向分组至少有两列。 ## 二、示例 ### 1.创建数据集test ``` { "data": [{ "region": "华东", "sales": 1000, "gifts": 100, "month": "1月", "province": "安徽", "city": "合肥" },{ "region": "华东", "sales": 1000, "gifts": 100, "month": "1月", "province": "安徽", "city": "安庆" },{ "region": "华东", "sales": 1000, "gifts": 100, "month": "2月", "province": "安徽", "city": "安庆" },{ "region": "华东", "sales": 1000, "gifts": 100, "month": "2月", "province": "安徽", "city": "合肥" },{ "region": "华北", "sales": 1000, "gifts": 100, "month": "1月", "province": "河北", "city": "邯郸" },{ "region": "华北", "sales": 1000, "gifts": 100, "month": "2月", "province": "河北", "city": "邯郸" },{ "region": "华南", "sales": 2000, "gifts": 200, "month": "2月", "province": "广东", "city": "广州" },{ "region": "华南", "sales": 3000, "gifts": 300, "month": "1月", "province": "广东", "city": "广州" },{ "region": "华南", "sales": 5000, "gifts": 600, "month": "1月", "province": "广东", "city": "深圳" },{ "region": "华南", "sales": 6000, "gifts": 600, "month": "2月", "province": "广东", "city": "深圳" },{ "region": "华北", "sales": 7000, "gifts": 600, "month": "2月", "province": "河北", "city": "唐山" },{ "region": "华北", "sales": 7000, "gifts": 600, "month": "1月", "province": "河北", "city": "唐山" },{ "region": "华南", "sales": 2000, "gifts": 200, "month": "2月", "province": "广西", "city": "南宁" },{ "region": "华南", "sales": 3000, "gifts": 300, "month": "1月", "province": "广西", "city": "南宁" },{ "region": "华南", "sales": 5000, "gifts": 600, "month": "1月", "province": "广西", "city": "桂林" },{ "region": "华南", "sales": 6000, "gifts": 600, "month": "2月", "province": "广西", "city": "桂林" }] } ``` ### 2.设计界面如下(分组基本配置步骤省略): ![](https://img.kancloud.cn/1f/02/1f02f3eb052baa4ad99df974ba42ada1_983x245.png) ### 3.设置分组依据 ![](https://img.kancloud.cn/a9/16/a916a5db6d11e7ef4893af8b40090244_1632x457.png) ### 4.设置计算字段 ![](https://img.kancloud.cn/70/7f/707fcf4c3201d23e3169af8bb8a484a0_1629x443.png) 预览效果: ![](https://img.kancloud.cn/42/b2/42b282cf4bfd25a4ebd8a205ffc570da_942x450.png) ### 5.重新设置分组依据,先设置省份的分组依据为否,然后设置地区的分组依据为是 ![](https://img.kancloud.cn/c3/67/c3678ec8473f5d84ff82154b4bae7797_1642x442.png) 预览效果: ![](https://img.kancloud.cn/b0/94/b0946d0e0524c14b3aedf65b42ab8a41_923x420.png) *对比,4、5预览效果,分组依据即小计计算的依据,根据这个依据字段,统计该分组下的数据值,然后在分组依据字段的下级列中显示`合计`行,所以限定至少有两列纵向分组*