6 Replies Latest reply: Aug 3, 2016 1:23 PM by John Cavoulas RSS

    Username/Department Roll-up Logic

    John Cavoulas

      Hello all,

       

      I've been struggling with some logic that will return department number roll-ups to the highest level, in this case the queen bees.

       

      My data is like this...

       

      UsernameTitleDepartmentManager
      JoeWorker Bee200King Bee 1
      MaryWorker Bee300King Bee 2
      LarryKing Bee 1450Queen Bee 1
      MoKing Bee 2475Queen Bee 2
      AnitaQueen Bee 1100
      ToniQueen Bee 2105
      El JeffeWorker Bee335King Bee 2
      ShempWorker Bee250King Bee 1

       

      I need to return data rolled up by Queen like this...

       

      Queen BeeDepartments
      Anita200
      Anita450
      Anita100
      Anita250
      Toni300
      Toni475
      Toni105
      Toni335

       

      Thanks,

      John