跳到主要内容

交叉表横向显示表格

概述​

交叉表横向显示表格：用交叉表实现表格数据的横向显示。

应用场景​

如下图所示，简单展示数据

image
Preview

示例说明​

数据准备​

在数据面板中添加数据集，可选择Json数据集和API服务数据集。Json数据集输入如下图所示：

[
{"CustomerID":"HUNGC","CompanyName":"五金机械","ContactName":"苏先生","ContactTitle":"销售代表","Address":"德昌路甲 29 号","City":"大连","Region":"东北","PostalCode":"564576","Country":"中国","Phone":"(053) 5556874","Fax":"(053) 5552376"},
{"CustomerID":"CENTC","CompanyName":"三捷实业","ContactName":"王先生","ContactTitle":"市场经理","Address":"英雄山路 84 号","City":"大连","Region":"东北","PostalCode":"130083","Country":"中国","Phone":"(061) 15553392","Fax":"(061) 15557293"},
{"CustomerID":"CACTU","CompanyName":"威航货运有限公司","ContactName":"刘先生","ContactTitle":"销售代理","Address":"经七纬二路 13 号","City":"大连","Region":"东北","PostalCode":"120412","Country":"中国","Phone":"(061) 11355555","Fax":"(061) 11354892"},
{"CustomerID":"BLONP","CompanyName":"国皓","ContactName":"黄雅玲","ContactTitle":"市场经理","Address":"广发北路 10 号","City":"大连","Region":"东北","PostalCode":"565479","Country":"中国","Phone":"(0671) 88601531","Fax":"(0671) 88601532"},
{"CustomerID":"MEREP","CompanyName":"华科","ContactName":"吴小姐","ContactTitle":"市场助理","Address":"和光北路 952 号","City":"大连","Region":"东北","PostalCode":"280235","Country":"中国","Phone":"(0514) 5558054","Fax":"(0514) 5558055"},
{"CustomerID":"GREAL","CompanyName":"仪和贸易","ContactName":"王先生","ContactTitle":"市场经理","Address":"经三纬四路 18 号","City":"北京","Region":"华北","PostalCode":"120475","Country":"中国","Phone":"(010) 65557555","Fax":""}
]

报表设计​

将数据字段拖入B1-B10单元格，并设置为分组以及向右扩展。
在上方工具栏-表格设置-数据展示-分组中选择不合并单元格。
选中A1-B10，点击上方工具栏-添加分组。

如下图所示

image
Preview

效果预览​

交叉表横向显示表格.json

image
Preview