I have a data set as shown below.
I want to make a tree structure by using Hierarchy function in QV
In the above table, hierarchy is defined in the form of position :
Now my requirement is I want to create hierarchy like
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