纵向分组小计
一、定义:
仅限于组合动态列分组中 用于动态属性的纵向小计,且纵向分组至少有两列。
二、示例
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预览效果,分组依据即小计计算的依据,根据这个依据字段,统计该分组下的数据值,然后在分组依据字段的下级列中显示合计
行,所以限定至少有两列纵向分组