Hi, I need to count the customers that I have in my datawarehouse. I have so many tables, two of these tables are the Master Client (with the information of customers like date-new-client, and date-dead-client, other table records all the transactions of my customers for each month, so, We must take care about many of these customers don´t purchase anything for many months. both two tables are conected by the Client´s Number.
this is my problem, I want to know for each month how many customers i have in my customer base, Including the whole who didn´t purchase anything but stay in my customer base now, the objective is simple, I want to know the number of non-buying something.
At first time, this is my algoritm´for help:
=COUNT( distinct IF((Date_Down_Client>=MonthYear or Date_Down_Client=0) AND Date_Up_Client<=MonthYear,NumberClient,''))
these are my variables:
Date_Down_Client: is the date when my customer gets dead, if this variable is O, then the customer is alive.
Date_Up_Client: is the date when we introduce the customer in our database.
MonthYear-> its the dimension of the table.
Thanks
Regards.
