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

    Alan Hendrickx

      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.

       

      E.g.

      Reports into

      Mr. Top

      Mr. Top

      Mr. OneLevelDown

      Mrs. One LevelDown

      Mr. OneLevelDown

      etc.

       

      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,

      P