good day everyone!
Please help me solve my problem regarding on how to know which customers have sales on specific month, because i need to know how many customers we have sales on every month.
I attached my raw data coming from our system.
thank you and God bless.
Hi Elinor
Your raw data is pretty messy (format and all) and very difficult to analyse 
I have added 2 helper columns to get the customer ID and Month of the Invoice.
I am counting the number of invoices issued for each customer (ignoring returns). So if a customer has a return but no invoice for a particular month, it will not be counted as a sales.
As I recall, you asked for something similar before :
Hope this helps.
Sunny
good day Sunny and to all,
Thank you very much for your reply and solution Mr. Sunny. Yes, sorry for my raw data is kinda messy because this was exported from our accoounting system. yes the same raw data format as before, last time total sales but now total number of customers that have sales every month. i did not change or edit my raw data because i want to create a format or template that everytime i will export data from our system, i will just copy and paste.
Again, thank you for the solution and God Bless you all!!!
