0 Replies Latest reply: Feb 4, 2017 1:55 AM by Patric Amatulli RSS

    PnL hierarchy field with indentations

    Patric Amatulli

      Hi guys,

       

      can somebody help me with this problem.

      I have a single field which reflects the account hierarchy with a lof of indentations like that:

       

      Capture.PNG

       

      I would like to transform the indent hierarchy in a flat hierarchy like (we have L1-L12). Is there a way to achieve the following output assuming that the indent Levels have always the same paddings?

       

      KeyLevel 1Level 2Level 3Level 4Level 5Level 6Level 7Level 8Level 9Level 10Level 11Level 12
      NetInc
      NetIncOpProf
      NetIncOpProfOpResult
      NetIncOpProfOpResultOpRevNetIntIncProv
      NetIncOpProfOpResultOpRevNetIntIncProvNetIntInc
      NetIncOpProfOpResultOpRevNetIntIncProvNetIntIncLB_DB
      NetIncOpProfOpResultOpRevNetIntIncProvNetIntIncLB_DBLB
      NetIncOpProfOpResultOpRevNetIntIncProvNetIntIncLB_DBLB5110R
      NetIncOpProfOpResultOpRevNetIntIncProvNetIntIncLB_DBLB5115R

       

      Attached you can find some dummy data of the delivered data.

       

      Thanks and regards,

      Patric