0 Replies Latest reply: Jul 7, 2011 8:57 AM by ALEXANDRE PERROT RSS

    Parents, children and brothers calcul with hierarchy

    ALEXANDRE PERROT

      Hi,

       

      I realised a hierarchy and I would like to know how to calculate father, children and brothers ? See below an extract of my hierarchy and what I try to do :

      Hierarchy calculation.bmp

       

      You will find attached XLS file with data. I've tried everything with set analysis or AGGR function but nothing to do.

      I need your help

       

      Thank you,

      Alex.