5 Replies Latest reply: Nov 25, 2016 5:28 PM by Marco Wedel RSS

    Agrupar Valores Repetidos

    Matheus Colares

      Hi, there is how do that?

      If(substringcount('001|002|003|004|005|006',STORE)>0,'Group1',If(substringcount('001|002|003',STORE)>0,'Group2',If(substringcount('004|005|006',STORE)>0,'Group3')))

       

      Just Group1 appears -off course-, because first condition...Have any way to do for 001  belong Group1 and Group2 at the same time?

       

      Thank you!!

       

      Attached have a sample what i want...i want that sales of store1 com belong a group1 and group2.