need to create Hierarchy

Fri, 08 Feb 2013 05:12:23 GMT

Hi All,

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

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

Re: need to create Hierarchy

khadeer — Fri, 08 Feb 2013 05:21:44 GMT

Hi,

Check the attached document.

Check the below link also.

Fri, 08 Feb 2013 06:19:54 GMT

In my case its not working .