1.效果图
2.数据准备
2.1 基础数据表
文件1:包含数据层级关系
level | level1 | level2 | level3 |
---|---|---|---|
2 | 1 | 1 | |
3 | 1 | 2 | a |
2 | 1 | 2 | |
3 | 1 | 3 | a |
3 | 1 | 3 | b |
3 | 1 | 3 | c |
2 | 1 | 3 | |
2 | 1 | 4 | |
1 | 1 | ||
3 | 2 | 1 | a |
3 | 2 | 1 | b |
2 | 2 | 1 | |
3 | 2 | 2 | a |
3 | 2 | 2 | c |
2 | 2 | 2 | |
3 | 2 | 3 | b |
3 | 2 | 3 | c |
2 | 2 | 3 | |
1 | 2 | ||
3 | 3 | 1 | a |
3 | 3 | 1 | b |
3 | 3 | 1 |