4 Replies Latest reply: Sep 22, 2017 9:02 AM by Riccardo Baitello RSS

    Problem with aggr()

    Riccardo Baitello

      Hi to everyone,

      I've a problem I can't solve. This is my table:

       

      Field_1Field_2
      AX
      A-
      AX
      A-
      B-
      BX
      B-
      B-
      BY

       

      this is what I need to obtain:

       

      Field_1Field_2
      AX
      BX, Y

       

      Using the Aggr() function:

       

      Aggr(Field_2,Field_1)

       

      I'm only able to obtain this:

       

      Field_1Field_2
      AX
      B-

       

      How can I extract also the 'Y'?

       

      Thanks a lot!