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.