9 Replies Latest reply: Oct 4, 2013 2:59 PM by Shanmukha Sreenivas RSS

    identifying new customers each month

    Aissam Boumejjane

      Hi Guys,

       

      I'm trying to create a new field in my script where i'm defyining new and old customers.

       

      Let's say we currentlty have 1 current customer in May. A month later a new customer is registered as a new customer.

      I would like to create a field that registers new customers per month.

       

      So in July the new customers in juni will automatically turn to CurrentCustomer.

       

      How can I achieve the above?

       

      I have three tables, one with dates fields, another with customerinfo, and last table is fact table. I need to create this field in my fact table.

       

      Please find attached my script.

       

      Regards,

       

      Sam