7 Replies Latest reply: Jul 13, 2015 5:53 AM by rgv rand RSS

    Count Exclude if any

    Hermawan Arsandi

      Hi guys,

       

      Got confused in some calculation.

      Doc No.      Item         Qty     Customer

      INV-01          A             2           ALPHA

      INV-01          B             1            ALPHA

      INV-02          B              2           DELTA

      INV-03          A              1            OMEGA

       

      i want to count how many customer that bought ITEM "B" only. so the correct answer should be "1"

      can anybody help ?