交叉表按月交叉
概述
交叉表按月交叉：按月交叉表，即通常所说的月报表。
应用场景
如下图所示，简单展示数据
Preview
示例说明
数据准备
在数据面板中添加数据集，可选择Json数据集和API服务数据集。Json数据集输入如下图所示：
[{"公司":"百达电子","日期":3,"金额":535.2},{"公司":"玉钰公司","日期":1,"金额":32},{"公司":"玉钰公司","日期":2,"金额":52},{"公司":"玉钰公司","日期":2,"金额":696.5},{"公司":"玉钰公司","日期":9,"金额":51},{"公司":"玉钰公司","日期":2,"金额":1060},{"公司":"大鱼系统","日期":11,"金额":52.6},{"公司":"大鱼系统","日期":11,"金额":390},{"公司":"大鱼系统","日期":10,"金额":56.5},{"公司":"高上公司","日期":3,"金额":500},{"公司":"高上公司","日期":3,"金额":400},{"公司":"光明杂志","日期":4,"金额":360},{"公司":"光明杂志","日期":4,"金额":16},{"公司":"光明杂志","日期":5,"金额":493},{"公司":"国顶有限公司","日期":4,"金额":36.5},{"公司":"国顶有限公司","日期":4,"金额":1060},{"公司":"国顶有限公司","日期":4,"金额":10},{"公司":"国顶有限公司","日期":7,"金额":590.4},{"公司":"国顶有限公司","日期":4,"金额":45},{"公司":"国皓","日期":5,"金额":15.5},{"公司":"国皓","日期":5,"金额":432},{"公司":"国皓","日期":12,"金额":635},{"公司":"国皓","日期":12,"金额":50},{"公司":"国皓","日期":12,"金额":115},{"公司":"国皓","日期":3,"金额":65},{"公司":"华科","日期":11,"金额":595.5},{"公司":"华科","日期":11,"金额":112.5},{"公司":"华科","日期":6,"金额":50},{"公司":"华科","日期":6,"金额":35},{"公司":"华科","日期":6,"金额":360},{"公司":"华科","日期":8,"金额":650},{"公司":"建国科技","日期":9,"金额":493},{"公司":"建国科技","日期":9,"金额":50},{"公司":"建国科技","日期":2,"金额":5},{"公司":"兰格公司","日期":3,"金额":60},{"公司":"兰格公司","日期":2,"金额":360},{"公司":"兰格公司","日期":2,"金额":56.35},{"公司":"瑞栈工艺","日期":9,"金额":396.5},{"公司":"瑞栈工艺","日期":9,"金额":65},{"公司":"森通","日期":6,"金额":52},{"公司":"森通","日期":6,"金额":65},{"公司":"伸格公司","日期":9,"金额":35},{"公司":"伸格公司","日期":4,"金额":36.5},{"公司":"伸格公司","日期":9,"金额":493},{"公司":"伸格公司","日期":9,"金额":20.5},{"公司":"伸格公司","日期":3,"金额":34},{"公司":"伸格公司","日期":3,"金额":55},{"公司":"伸格公司","日期":8,"金额":50},{"公司":"升格企业","日期":3,"金额":136.9},{"公司":"升格企业","日期":3,"金额":56},{"公司":"升格企业","日期":7,"金额":360},{"公司":"师玉公司","日期":12,"金额":650},{"公司":"师玉公司","日期":12,"金额":59},{"公司":"师玉公司","日期":7,"金额":20},{"公司":"坦森行公司","日期":9,"金额":52},{"公司":"坦森行公司","日期":9,"金额":602},{"公司":"坦森行公司","日期":1,"金额":560},{"公司":"通恒机械","日期":5,"金额":9.4},{"公司":"通恒机械","日期":5,"金额":16.5},{"公司":"通恒机械","日期":2,"金额":92},{"公司":"通恒机械","日期":5,"金额":32},{"公司":"五洲信托","日期":6,"金额":94.5},{"公司":"五洲信托","日期":6,"金额":650},{"公司":"协昌妮绒有限公司","日期":3,"金额":50},{"公司":"协昌妮绒有限公司","日期":2,"金额":50},{"公司":"协昌妮绒有限公司","日期":3,"金额":405.45},{"公司":"兴中保险","日期":5,"金额":55},{"公司":"兴中保险","日期":5,"金额":62.65},{"公司":"幸义房屋","日期":3,"金额":55},{"公司":"幸义房屋","日期":3,"金额":996.5},{"公司":"幸义房屋","日期":5,"金额":56.5},{"公司":"幸义房屋","日期":5,"金额":356.5},{"公司":"幸义房屋","日期":9,"金额":601},{"公司":"幸义房屋","日期":9,"金额":62},{"公司":"幸义房屋","日期":8,"金额":62}]
报表设计
将数据字段拖入A2、B1、B2单元格，并设置成分组。
将A2设置为向下扩展，B1设置为向右扩展，B2设置为双向扩展。
选中B1(test.日期)，点击上方工具栏-元素-设置显示格式，在添加后缀中加入“月”。
点击上方工具栏此按钮设置交叉表表头，用 | 分隔。
如下图所示
Preview
效果预览
Preview