6 Replies Latest reply: Mar 11, 2015 2:55 PM by Staffan Johansson RSS

    Sum with aggr or total?

      Hi all!

       

      I have a table similar below, where I need count people in groups A and in subgroups A1. In the sum for A1 the expression that Im use is:  sum(Ind_Ative) and this WORKS OK. But in the sum for a group A, I need that total for a group is repeated in all lines for the group. Im use the expression: sum(aggr ( sum(Ind_Ative), Group_A))

      But the result is like below, where the value just appear in one lines.

      Any idea?

       

      Thanks!

       

      Group AGroup A1Ind_Active for group A1Ins_Active  for Group A
      23100
      1291590590
      1661117205
      1662160
      166420
      1666700
      200121470
      2002192363
      2004780
      20051160
      200600
      200820
      200910
      2001000
      2011619
      201230
      2013100