6 Replies Latest reply on Feb 8, 2018 5:26 PM by Chris McClellan

    HR Hierarchy

    Drew Upah

      This may be an easy solution and I am just missing it. I need to assign levels based on Party ID and Manager Party ID. For example, in the table below:

       

       

      John Snow -- CEO (Level 1)

           Peyton Manning -- Level 2

           Jack Colby -- Level 2

           Steve Smith -- Level 2

                Jim Klue -- Level 3

                Rick Fryer -- Level 3

       

      Anyone know how I can write this? I am trying to build an org chart. I have attached a workbook for an example.