跳到主要内容

纵向分组小计

一、定义:

仅限于组合动态列分组中 用于动态属性的纵向小计,且纵向分组至少有两列。

二、示例

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.设计界面如下(分组基本配置步骤省略):

3.设置分组依据

4.设置计算字段

预览效果:

5.重新设置分组依据,先设置省份的分组依据为否,然后设置地区的分组依据为是

预览效果:

对比,4、5预览效果,分组依据即小计计算的依据,根据这个依据字段,统计该分组下的数据值,然后在分组依据字段的下级列中显示合计行,所以限定至少有两列纵向分组