3 Replies Latest reply: Mar 1, 2013 3:13 AM by andormak RSS

    Aggr function?

      Hi,

       

      I have following table:

       

      X,Y

       

      A,1

      A,2

      A,3

      B,1

      B,2

      C,2

      C,3

       

      The result that I am looking for is an aggregation/subtotal in every row in a new column:

       

      X,Y,Z

       

      A,1,6

      A,2,6

      A,3,6

      B,1,3

      B,2,3

      C,2,5

      C,3,5

       

      Furhtermore I am looking for the calculation of the shares:

       

      X;Y;Z;XY

       

      A;1;6;0,16

      A;2;6;0,33

      A;3;6;0,5

      B;1;3;0,33

      B;2;3;0,66

      ...

       

       

      Could somebody please help me solving this issue?

      Thank you verry much.

       

      Kind regards,

       

      Andi.