2 Replies Latest reply: Nov 3, 2015 9:34 PM by Hermawan Arsandi RSS

    Count with 3 Value in 1 Dimension fulfill

      Dear All,

      Can anybody help for one case that i facing   

       

      Case :

      i want to count how many people that bought all PEN , BOOK and ERASER  (if they bought BOOK and ERASER, not counted)

      and have to be distinct.

      the correct answer should be = 2 --> A and D

      DATENAMEITEMQTY
      1-NovABOOK1
      1-NovAPEN1
      1-NovBERASER1
      1-NovBBOOK1
      1-NovCBOOK1
      2-NovAERASER1
      2-NovDBOOK1
      2-NovDPEN1
      2-NovDERASER1
      2-NovEMAGAZINE1
      2-NovEMAGAZINE1
      2-NovDBOOK1

       

      Thanks in advance