6 Replies Latest reply: Feb 13, 2018 3:44 AM by Mohammad Adnan Ansari RSS

    New & Repeat customers

    Mohammad Adnan Ansari

      I have a retail sales database with the below information:

       

      Date

      Invoice No

      Customer No

      Sales

       

       

      I need to find out

       

      how much are the new customers in 2017 and 2018? 

      How much are the repeat customers in 2018 from the list of new customers in 2017?

      How much are the repeat customers in 2018 overall?