>小計：是指數字列表的一部分的總和 >縱向分組小計：是指每個縱向分組下的小計 # 縱向分組小計 [TOC] ## 示例1—不存在橫向分組小計 ### 1、效果展示 縱向分組小計：[點擊預覽示例1](https://bootapi.jeecg.com/jmreport/view/590808622016319488) 以地區為分組依據，計算銷售金額合計；`合計`兩個字展示在省份下。  ### 2、創建一個名為`區域省份銷售統計`的數據報表 > 創建一個區域銷售表，有七個字段：ID、數量、區域名稱、年、省份、價格、月份  #### 2.1 為`區域省份銷售統計`創建SQL數據源  >部分數據展示  #### 2.2 將字段拖拽到設計器頁面  #### 2.3 設置縱向分組、橫向分組、動態屬性 >[danger]此步驟涉及到`橫向縱向組合動態列`和`交叉報表` 橫向縱向組合動態列請參考 [橫向縱向組合動態列](http://report.jeecg.com/2119057) 交叉報表請參考 [交叉報表](http://report.jeecg.com/2112709) * 地區(areaname)縱向分組： `#{jm.group(areaname)}` * 省份(province)縱向分組：` #{jm.group(province)}` * 年份(year)橫向分組： `#{jm.groupRight(year)}年` * 月份(month)橫向分組： `#{jm.groupRight(month)}月` * 銷售額(amount)動態屬性：`#{jm.dynamic(amount)}`  #### 2. 4、重點來了->設置分組小計 >[danger] 特別注意：本例中` #{jm.group(areaname)}`為分組依據字段、`#{jm.group(province)}`為分組字段，則合計可正常顯示，”合計“兩個字展示在省份下；自1.4.0版本開始當只有分組依據字段，無其他分組字段時，”合計“兩個字自動展示在分組字段后一個字段中。 >`#{jm.group(areaname)}`設置為分組依據  >`#{jm.dynamic(amount)}`設置為`求和`  >保存預覽  ## 示例2—存在橫向分組小計 ### 1、效果展示 組合分組小計：[點擊預覽示例2](https://bootapi.jeecg.com/jmreport/view/590812531803901952) 以區域為分組依據，設置縱向小計和橫向小計 小計：橫向計算，單價*金額 合計：金額列組內相加  ### 2、創建一個名為`區域省份銷售統計`的數據報表 > 創建一個區域銷售表，有七個字段：ID、數量、區域名稱、年、省份、價格、月份  #### 2.1 為`區域省份銷售統計`創建SQL數據源  >部分數據展示  #### 2.2 將字段拖拽到設計器頁面  #### 2.3 設置橫向分組、縱向分組、動態屬性、橫向小計 >[danger]此步驟涉及到`橫向縱向組合動態列`和`交叉報表`和`橫向分組小計` 橫向縱向組合動態列請參考 [橫向縱向組合動態列](http://report.jeecg.com/2119057) 交叉報表請參考 [交叉報表](http://report.jeecg.com/2112709) 橫向分組小計請參考 [橫向分組小計](http://report.jeecg.com/2250464) * 地區(areaname)縱向分組： `#{jm.group(areaname)}` * 部門(province)縱向分組： `#{jm.group(province)}` * 年份(year)橫向分組： `#{jm.groupRight(year)}年` * 月份(month)橫向分組： `#{jm.groupRight(month)}月` * 動態字段： 單價(`#{jm.dynamic(price)}`) 金額(`#{jm.dynamic(amount)}`) 小計(`#{jm.compute(price*amount)}`)  #### 2.4、重點來了->設置分組小計 >[danger] 特別注意：本例中`#{jm.group(areaname)}`為分組依據字段、`#{jm.group(dept)}`為分組字段，則合計可正常顯示，”合計“兩個字展示在省份下；自1.4.0版本開始當只有分組依據字段，無其他分組字段時，”合計“兩個字自動展示在分組字段后一個字段中。 > `#{jm.group(areaname)}`設置為分組依據  >`#{jm.dynamic(amount)}`設置成求和列  >保存預覽  ## 特殊規則注意 >[danger]設置動態單元格類型 當數據不完整時系統默認會進行補0操作便于小計表達式計算，如果該單元格不是數值類型則需要設置為文本，設置文本后該單元格顯示為空；如：`備注`字段為空時，不需要展示為0，則設置備注字段類型為`文本`。  ## 數據格式 重要！！！(數據必須完整) >[danger] 特別注意：當有橫向分組時，數據中第一條`數據必須完整`；例如：期望展示1-12月的數據，則第一條數據1-12月必須都有數據。 * SQL數據：  * 返回JSON格式： ``` { "data": [{ "amount": "100", "month": "1", "areaname": "華北", "year": "2020", "price": "5", "id": "1", "dept": "河北", "settleamount": "100" }, { "amount": "200", "month": "2", "areaname": "華北", "year": "2020", "price": "5", "id": "10", "dept": "河北", "settleamount": "200" }, { "amount": "202", "month": "2", "areaname": "華北", "year": "2020", "price": "6", "id": "12", "dept": "河南", "settleamount": "202" }, { "amount": "203", "month": "1", "areaname": "華東", "year": "2020", "price": "6", "id": "13", "dept": "遼寧", "settleamount": "203" }, { "amount": "204", "month": "2", "areaname": "華東", "year": "2020", "price": "6", "id": "14", "dept": "遼寧", "settleamount": "204" }, { "amount": "205", "month": "1", "areaname": "華南", "year": "2020", "price": "5", "id": "15", "dept": "湖北", "settleamount": "205" }, { "amount": "206", "month": "2", "areaname": "華南", "year": "2020", "price": "5", "id": "16", "dept": "湖北", "settleamount": "206" }, { "amount": "207", "month": "1", "areaname": "華南", "year": "2020", "price": "5", "id": "17", "dept": "安徽", "settleamount": "207" }, { "amount": "208", "month": "2", "areaname": "華南", "year": "2020", "price": "5", "id": "18", "dept": "安徽", "settleamount": "208" }, { "amount": "201", "month": "2", "areaname": "華北", "year": "2021", "price": "5", "id": "20", "dept": "河北", "settleamount": "201" }, { "amount": "200", "month": "1", "areaname": "華北", "year": "2021", "price": "5", "id": "21", "dept": "河北", "settleamount": "200" }, { "amount": "202", "month": "2", "areaname": "華北", "year": "2021", "price": "6", "id": "22", "dept": "河南", "settleamount": "202" }, { "amount": "209", "month": "1", "areaname": "華北", "year": "2021", "price": "6", "id": "23", "dept": "河南", "settleamount": "209" }, { "amount": "202", "month": "1", "areaname": "華北", "year": "2020", "price": "6", "id": "24", "dept": "河南", "settleamount": "202" }, { "amount": "203", "month": "1", "areaname": "華東", "year": "2021", "price": "6", "id": "25", "dept": "遼寧", "settleamount": "203" }, { "amount": "204", "month": "2", "areaname": "華東", "year": "2021", "price": "6", "id": "26", "dept": "遼寧", "settleamount": "204" }, { "amount": "205", "month": "1", "areaname": "華南", "year": "2021", "price": "5", "id": "27", "dept": "湖北", "settleamount": "205" }, { "amount": "206", "month": "2", "areaname": "華南", "year": "2021", "price": "5", "id": "28", "dept": "湖北", "settleamount": "206" }, { "amount": "207", "month": "1", "areaname": "華南", "year": "2021", "price": "5", "id": "29", "dept": "安徽", "settleamount": "207" }, { "amount": "208", "month": "2", "areaname": "華南", "year": "2021", "price": "5", "id": "30", "dept": "安徽", "settleamount": "208" }, { "amount": "203", "month": "1", "areaname": "華東", "year": "2020", "price": "6", "id": "43", "dept": "天津", "settleamount": "203" }, { "amount": "204", "month": "2", "areaname": "華東", "year": "2020", "price": "6", "id": "44", "dept": "天津", "settleamount": "204" }, { "amount": "203", "month": "1", "areaname": "華東", "year": "2021", "price": "6", "id": "45", "dept": "天津", "settleamount": "203" }, { "amount": "204", "month": "2", "areaname": "華東", "year": "2021", "price": "6", "id": "46", "dept": "天津", "settleamount": "204" }] } ```