交叉表按日交叉
概述
交叉表按日交叉：按日交叉表，即通常所说的日报表。
应用场景
如下图所示，简单展示数据
Preview
示例说明
数据准备
在数据面板中添加数据集，可选择Json数据集和API服务数据集。Json数据集输入如下图所示：
[{"公司":"百达电子","日期":3,"金额":535.2},{"公司":"玉钰公司","日期":1,"金额":322},{"公司":"玉钰公司","日期":2,"金额":1520},{"公司":"玉钰公司","日期":2,"金额":696.5},{"公司":"玉钰公司","日期":29,"金额":51},{"公司":"玉钰公司","日期":2,"金额":1060},{"公司":"大鱼系统","日期":11,"金额":252.6},{"公司":"大鱼系统","日期":11,"金额":390},{"公司":"大鱼系统","日期":10,"金额":156.5},{"公司":"高上公司","日期":3,"金额":2500},{"公司":"高上公司","日期":3,"金额":1400},{"公司":"光明杂志","日期":24,"金额":360},{"公司":"光明杂志","日期":24,"金额":116},{"公司":"光明杂志","日期":15,"金额":493},{"公司":"国顶有限公司","日期":4,"金额":236.5},{"公司":"国顶有限公司","日期":4,"金额":1060},{"公司":"国顶有限公司","日期":4,"金额":210},{"公司":"国顶有限公司","日期":7,"金额":590.4},{"公司":"国顶有限公司","日期":4,"金额":45},{"公司":"国皓","日期":5,"金额":115.5},{"公司":"国皓","日期":5,"金额":432},{"公司":"国皓","日期":12,"金额":635},{"公司":"国皓","日期":12,"金额":150},{"公司":"国皓","日期":12,"金额":1125},{"公司":"国皓","日期":30,"金额":625},{"公司":"华科","日期":11,"金额":595.5},{"公司":"华科","日期":11,"金额":112.5},{"公司":"华科","日期":16,"金额":2250},{"公司":"华科","日期":16,"金额":315},{"公司":"华科","日期":6,"金额":360},{"公司":"华科","日期":28,"金额":650},{"公司":"建国科技","日期":9,"金额":493},{"公司":"建国科技","日期":9,"金额":50},{"公司":"建国科技","日期":2,"金额":25},{"公司":"兰格公司","日期":13,"金额":260},{"公司":"兰格公司","日期":2,"金额":360},{"公司":"兰格公司","日期":2,"金额":156.35},{"公司":"瑞栈工艺","日期":9,"金额":396.5},{"公司":"瑞栈工艺","日期":9,"金额":165},{"公司":"森通","日期":26,"金额":252},{"公司":"森通","日期":26,"金额":65},{"公司":"伸格公司","日期":19,"金额":35},{"公司":"伸格公司","日期":14,"金额":36.5},{"公司":"伸格公司","日期":19,"金额":493},{"公司":"伸格公司","日期":19,"金额":200.5},{"公司":"伸格公司","日期":23,"金额":234},{"公司":"伸格公司","日期":23,"金额":155},{"公司":"伸格公司","日期":8,"金额":150},{"公司":"升格企业","日期":30,"金额":1236.9},{"公司":"升格企业","日期":30,"金额":516},{"公司":"升格企业","日期":17,"金额":360},{"公司":"师玉公司","日期":12,"金额":650},{"公司":"师玉公司","日期":12,"金额":159},{"公司":"师玉公司","日期":27,"金额":2200},{"公司":"坦森行公司","日期":19,"金额":520},{"公司":"坦森行公司","日期":19,"金额":602},{"公司":"坦森行公司","日期":21,"金额":560},{"公司":"通恒机械","日期":15,"金额":209.4},{"公司":"通恒机械","日期":15,"金额":116.25},{"公司":"通恒机械","日期":22,"金额":920},{"公司":"通恒机械","日期":15,"金额":320},{"公司":"五洲信托","日期":6,"金额":194.5},{"公司":"五洲信托","日期":6,"金额":2650},{"公司":"协昌妮绒有限公司","日期":23,"金额":150},{"公司":"协昌妮绒有限公司","日期":20,"金额":250},{"公司":"协昌妮绒有限公司","日期":23,"金额":405.45},{"公司":"兴中保险","日期":25,"金额":155},{"公司":"兴中保险","日期":25,"金额":162.65},{"公司":"幸义房屋","日期":3,"金额":155},{"公司":"幸义房屋","日期":3,"金额":996.5},{"公司":"幸义房屋","日期":5,"金额":156.15},{"公司":"幸义房屋","日期":5,"金额":356.5},{"公司":"幸义房屋","日期":9,"金额":1601},{"公司":"幸义房屋","日期":9,"金额":620},{"公司":"幸义房屋","日期":18,"金额":62}]
报表设计
将数据字段拖入A2、B1、B2单元格，并设置成分组。
将A2设置为向下扩展，B1设置为向右扩展，B2设置为双向扩展。
选中B1(test.日期)，点击上方工具栏-元素-设置显示格式，在添加后缀中加入“日”。
点击上方工具栏此按钮设置交叉表表头，用 | 分隔。
如下图所示
Preview
效果预览
Preview