3 Replies Latest reply: May 27, 2013 7:18 AM by Henric Cronström RSS

    Creating a Hierarchy based on a single column of data

      Hi All,


      I have a single column of reporting manager names (with other associated information).


      What I need to be able to do is create a structure which creates a hierarchy within the managment column. The column contains the name of the manager that each resource reports into.



      Reports into

      Mr. Top

      Mr. Top

      Mr. OneLevelDown

      Mrs. One LevelDown

      Mr. OneLevelDown



      Based on this data I believe I need something that looks like this which will enable me to select a Manager name and see the staff that report into them:

      Level      | Name

      1                 Mr. Top

      2                 Mr. OneLevelDown

      2                 Mrs. OneLevelDown


      Is this possible? If so how do I do this?


      Is there a better solution?


      This needs to be dynamic as the list will change on a monthly basis.


      Many thanks,