Forum Discussion
Calculation New, Repeat Customer
Hi,
CT01718 has transactions in Aug and Sep as well.
The same if true for CT03498 as well.
Please recheck.
Hi Ashish_Mathur,
Yes, however we're comparing current and last month to find how many new and repeat of customer in the current that we stand.
So all questions that raised in Oct and compare to Sep. If we're standing in Sep then compare to Aug.
Please kindly check and advise.
Thanks and Regards,
In the month filter drop down, select only one month - October. Both those codes have transactions in September and therefore for the month of October, they should both be classified as Repeat.
Hi Ashish_Mathur,
One customer have multiple sales team serviced (sell different brand/category), if you check this customer code: CT01718 will see transcation from Aug till Oct. But we filter by sales team = Food1, Brand = Kingfisher then have transcation in Aug & Oct.
So if we're standing in Oct, then this customer is New because no transcation in Sep.
Please check and advise.
Hi,
Please check now. File attached.
Hi Ashish_Mathur,
I have checked your file, the number is more than I count manually in excel.
This result is distinct count in excel file.
Please check and advise.
How do you expect me to help you with just that statement. DIY. Solve it by yourself now.
Hi Ashish_Mathur,
Just feedback what I see however still need your support and advise. sometimes we misunderstand or wrong explain then result also are different.
Thanks and Regards,
I really do not know how ealse to help you. Create a small dataset and try my formulas on that small dataset. See if you get the perfect result there or not. If there is a problem even on that small dataset, then we will revise the formula. Finally we will then plug in your large dataset. Please send time on doing this checking yourself.