10 Replies Latest reply: Mar 21, 2016 1:45 PM by Gysbert Wassenaar RSS

    Finding the same customer who made duplicate transaction in 12 months

    chee siong koh

      Hi All,

       

      I like to seek your kind assistance on the question below.

       

      I would like to find who are the distinct customer who made 2 or more transaction within 12 months. I have created a sample table  and the right answer should be highlighting:

      1) Customer A (as there are 2 transactions within 8 months)

       

      2) Customer D (as there are 2 transactions within 11 months)

       

      Can someone advise me pls.

       

         

      Customer Transaction Date (MM/YYYY)
      AApr-14
      BApr-14
      C May-14
      DJun-14
      ADec-15
      BMay-15
      C Jun-15
      DMay-15