4 Replies Latest reply on Jul 20, 2015 12:09 AM by Mira Shen

    Can I goup subjects who used multiple products under one field?

    Mira Shen



      I have subject using multiple products under one field as below


      Subject_ID      Products

      subj1                  A

      subj1                  B

      subj1                  C

      subj2                  A

      subj2                  C

      subj2                  D

      subj3                  B

      subj3                  D

      subj4                  B

      subj4                  D


      I like to group subjects like:

      if product=A AND product=C then Group="A+C"

      elseif product=B AND product=D then Group="B+D"



      Normal conditional function doesn't seem to work here.


      I am looking forward to your help. Thanks in advance.