6 Replies Latest reply: Dec 17, 2017 11:39 PM by Adwitiya Borah RSS

    Set Analysis formula

    Mohammad Adnan Ansari

      I am working with a retail system with single store.

       

      I have sales data in the QVD file with the below columns:

       

      DATE

      INVOICE NO

      ITEM

      SOLD QTY

      SALES AMOUNT

      CUSTOMER MOBILE NO

       

      I am using standard MASTER CALENDAR.

       

      One of the requirement is to create customer retention report.

       

      User has the filter for MONTH. If he selects JAN-2017 for example, I have to show how much times the customer visits us during this month (its easy). Customer is recognized by his Mobile No. The tricky part is I have to take the same Customer list (from the month which the user selected) and find out how much are those customer's (for each customer) visits during the month of Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov and Dec. Basically I need to find out who are the repeat customers.

       

      I think that this is a Set Analysis question but I don't know how to do it.