3 Replies Latest reply on Aug 16, 2018 12:34 AM by Zhouyi Zhang

    Group members based on their sum

    Sanket Deshpande

      Hello all,

       

      Consider the foll.sample data.

      what i want is to group ID whose sum lies between count 190 to 210.

      Say   for eg 2 and 3 sum to 192, similarly  if it were 2 and 5 then that will be a group so they will be in one group and so on

       

       

      IDCount
      131
      256
      3136
      4124
      5214
      641
      775
      885
      9162
      1061
      114
      12164
      1369
      14100
      1588
      1674
      17198
      18125
      1989
      20183

       

       

      Please help,

      Regards,

      Sanket