2 Replies Latest reply on Mar 30, 2016 7:35 AM by Ken Koh

    How frequent does the same customer (duplicate customer) appear and Who are the same customer (Duplicate customer) within 12 months

    Ken Koh

      I have a excel table (subset of this data is shown below) which I will be loading in.

       

       

      Customer Quarterly Index
      AApr-14
      BApr-14
      C Apr-14
      DApr-14
      A

      Feb-15

      BMar-15
      C Apr-15
      DJun-15
      AJuly-16
      BFeb-16
      C Mar-16
      DJun-16

       

      I would like to know:

      1. How frequent does the same customer (duplicate customer) appear

       

      2. Who are the same customer (Duplicate customer) within 12 months