0 Replies Latest reply: Oct 18, 2011 6:15 AM by Claudia Zwick RSS

    How to write this pivot table expression in script?

      Hi everybody,

       

      I load datas with HIERACHRY LOAD, then I build a pivot table with the parent and the childs as dimension. The expression is

       

      sum(piece)

      * if(not IsNu

      ll(child3), sum(total <child2> if(IsNull(child3), piece)),1)

      * if(not IsNull(child2), sum(total <child1> if(IsNull(child2), piece)),1)

       

      So I got the right piece in dependence of the ancestors. The deficit is, that I have to add all the childs in dimension.

       

      No I search for a solution, that I only give the parent and a list of all childs in one field with the correct piece number. I try it with and combination of HIERARCHY LOAD and HIERARCHYBELOANGSTO LOAD, but I loose then items or I hadn't the correct number of pieces.

       

      Any suggestions?

       

      Regards Vicky

      image_jpeg.jpg