2 Replies Latest reply on Aug 21, 2018 3:45 AM by 宁 卫

    Please Help with Organization Hierarchy Count

    宁 卫

      Hi,

       

      I've got a tricky problem that bugs me for days. The data is shown as below, It's an organization hierarchy table, each letter stands for a different hierarchy in an organization.

      I need a cal field that could count how many sub-hierarchies does each hierarchy have, for example, the hierarchy A_B has 9 sub-hierarchies, A_C has 7 sub-hierarchies

      and A _B_E has 4 sub-hierarchies and so forth. Please tell how to do this, thanks.

       

      20180821 174215.png