Log In
Register
Home
March 16, 2015
Offline
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.
See Answer
VIP
Trusted Members
June 25, 2016
Offline
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 :
https://www.myonlinetraininghu.....-per-month
Hope this helps.
Sunny
Answers Post
March 16, 2015
Offline
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!!!
1 Guest(s)
