Hi All,
I have a data set as shown below.
I want to make a tree structure by using Hierarchy function in QV
| name | ID | position |
| 郑炜 | 809956 | salesman |
| 杨建栋 | 700010 | DSM |
| 杨莉 | 700020 | DSM |
| 于波 | 700030 | DSM |
| 张鹏 | 700040 | DSM |
| 杭益智 | 700050 | DSM |
| 邬津萍 | 700060 | DSM |
| 张荣 | 700070 | DSM |
| 朱刚 | 700080 | DSM |
| 皇甫少陵 | 700090 | DSM |
| 汪泯 | 700100 | DSM |
| 赵利 | 700110 | RSM |
| 刘毅浜 | 700120 | RSM |
| 林奕 | 700130 | RSM |
| 吴团正 | 700140 | SRSM |
| 刘军 | 700150 | SRSM |
| 林伟彬 | 700160 | RSM |
| 张建军 | 809864 | salesman |
In the above table, hierarchy is defined in the form of position :
Now my requirement is I want to create hierarchy like
LEVEL1 SRSM
LEVEL2 RSM
LEVEL3 DSM
LEVEL4 SALESMAN
For Example:
SRSM
RSM
DSM
SALESMAN
SRSM should have all the IDs that SRSM have like in the above example it is 700140 , 700150
then under SRSM there should be all the ID's and NAME which are reporting to SRSM i.e. RSM (ID's and Name) like 700160 ,700130 and so on.
Please help me
Very urgent
