Hi,
I have sceneria like :
I have customer Name, ID, Year Month, Qty, Month etc..
Suppose One of the customer doing the transaction with me every month in JAN-2014, FEB-2014, MAR-2014. But if he is not done any transaction in APR-2014 and MAY-2014 and In JUN-2014 Again he has done some transaction. I have to find the total number of customer for that month in the list of total customer for JUN-2014.
This is apply for each month or gap of two months. for the data I have attached some xls, please find the attached xls. Thanks for the same.
waiting for reply for reply.
Regards,
Amit Kumar
