折叠树报表
概述
折叠树是一种以树形结构展示层级数据，并支持节点折叠/展开交互的可视化形式，广泛应用于数据展示、导航菜单、文件目录等场景。
应用场景
如下图所示，简单展示数据
Preview
示例说明
数据准备
在数据面板中添加数据集，可选择Json数据集和API服务数据集。Json数据集输入如下图所示：
"Company":
[{"city":"北京","year":2023,"month":1,"sales":24000,"quarter":1,"quantity":120,"unit_price":200,"company_name":"恒通贸易","product_name":"智能手环"},{"city":"上海","year":2023,"month":2,"sales":21000,"quarter":1,"quantity":105,"unit_price":200,"company_name":"恒通贸易","product_name":"智能手环"},{"city":"广州","year":2023,"month":3,"sales":27000,"quarter":1,"quantity":135,"unit_price":200,"company_name":"恒通贸易","product_name":"智能手环"},{"city":"深圳","year":2023,"month":4,"sales":36000,"quarter":2,"quantity":120,"unit_price":300,"company_name":"恒通贸易","product_name":"无线耳机"},{"city":"杭州","year":2023,"month":5,"sales":33000,"quarter":2,"quantity":110,"unit_price":300,"company_name":"恒通贸易","product_name":"无线耳机"},{"city":"成都","year":2023,"month":6,"sales":39000,"quarter":2,"quantity":130,"unit_price":300,"company_name":"恒通贸易","product_name":"无线耳机"},{"city":"武汉","year":2023,"month":7,"sales":150000,"quarter":3,"quantity":30,"unit_price":5000,"company_name":"远大科技","product_name":"笔记本电脑"},{"city":"南京","year":2023,"month":8,"sales":160000,"quarter":3,"quantity":32,"unit_price":5000,"company_name":"远大科技","product_name":"笔记本电脑"},{"city":"重庆","year":2023,"month":9,"sales":140000,"quarter":3,"quantity":28,"unit_price":5000,"company_name":"远大科技","product_name":"笔记本电脑"},{"city":"西安","year":2023,"month":10,"sales":80000,"quarter":4,"quantity":40,"unit_price":2000,"company_name":"远大科技","product_name":"平板电脑"},{"city":"青岛","year":2023,"month":11,"sales":90000,"quarter":4,"quantity":45,"unit_price":2000,"company_name":"远大科技","product_name":"平板电脑"},{"city":"沈阳","year":2023,"month":12,"sales":110000,"quarter":4,"quantity":55,"unit_price":2000,"company_name":"远大科技","product_name":"平板电脑"},{"city":"苏州","year":2024,"month":1,"sales":250000,"quarter":1,"quantity":50,"unit_price":5000,"company_name":"鑫源电子","product_name":"智能手机"},{"city":"无锡","year":2024,"month":2,"sales":220000,"quarter":1,"quantity":44,"unit_price":5000,"company_name":"鑫源电子","product_name":"智能手机"},{"city":"宁波","year":2024,"month":3,"sales":280000,"quarter":1,"quantity":56,"unit_price":5000,"company_name":"鑫源电子","product_name":"智能手机"},{"city":"合肥","year":2024,"month":4,"sales":45000,"quarter":2,"quantity":30,"unit_price":1500,"company_name":"鑫源电子","product_name":"智能手表"},{"city":"郑州","year":2024,"month":5,"sales":51000,"quarter":2,"quantity":34,"unit_price":1500,"company_name":"鑫源电子","product_name":"智能手表"},{"city":"长沙","year":2024,"month":6,"sales":48000,"quarter":2,"quantity":32,"unit_price":1500,"company_name":"鑫源电子","product_name":"智能手表"},{"city":"福州","year":2024,"month":7,"sales":18000,"quarter":3,"quantity":60,"unit_price":300,"company_name":"聚力商贸","product_name":"蓝牙音箱"},{"city":"厦门","year":2024,"month":8,"sales":21000,"quarter":3,"quantity":70,"unit_price":300,"company_name":"聚力商贸","product_name":"蓝牙音箱"},{"city":"昆明","year":2024,"month":9,"sales":15000,"quarter":3,"quantity":50,"unit_price":300,"company_name":"聚力商贸","product_name":"蓝牙音箱"},{"city":"贵阳","year":2024,"month":10,"sales":12000,"quarter":4,"quantity":120,"unit_price":100,"company_name":"聚力商贸","product_name":"移动电源"},{"city":"兰州","year":2024,"month":11,"sales":14000,"quarter":4,"quantity":140,"unit_price":100,"company_name":"聚力商贸","product_name":"移动电源"},{"city":"乌鲁木齐","year":2024,"month":12,"sales":16000,"quarter":4,"quantity":160,"unit_price":100,"company_name":"聚力商贸","product_name":"移动电源"},{"city":"哈尔滨","year":2025,"month":1,"sales":26000,"quarter":1,"quantity":124,"unit_price":210,"company_name":"恒通贸易","product_name":"智能手环"},{"city":"长春","year":2025,"month":2,"sales":42000,"quarter":1,"quantity":131,"unit_price":320,"company_name":"恒通贸易","product_name":"无线耳机"},{"city":"大连","year":2025,"month":3,"sales":170000,"quarter":1,"quantity":32,"unit_price":5200,"company_name":"远大科技","product_name":"笔记本电脑"}]
报表设计
将数据字段拖入相对应的位置，并设置为分组(合并单元格)以及向下扩展。
将A1-C1、A2-C2、A3-C3合并单元格。
将数据字段拖入A1、B1、C1单元格。
将A1、B1、C1表格设置为分组。
将A1、B1、C1设置为向下扩展.
选中A1-C3，点击上方工具栏-添加分组。
如下图所示
Preview
点击表样设置，选择树形报表。
如下图所示
Preview
效果预览
Preview