Forum Discussion
Helper IISub totals not summarizing correctly
It depends on how you define a returning customer.
If it is the difference between customers and new customers, 0 is the right answer at the year level.
A new customer in January that returns in April, is still a new customer when you look at the year level.
If you want to implement a different definition, you have to change the calculation logic.
Marco Russo - SQLBI
Most Valuable ProfessionalIt depends on how you define a returning customer.
If it is the difference between customers and new customers, 0 is the right answer at the year level.
A new customer in January that returns in April, is still a new customer when you look at the year level.
If you want to implement a different definition, you have to change the calculation logic.
Marco Russo - SQLBI
Helper IIMarco,
Thank you for taking time to reply. I understand know....your calculation for the Customers column is identifying Unique Customer's for each month and the yearly/annual sub-totals equal Unique Customers for that Year. I was adding up annual customers by totaling unique customers per month -- which is not correct - Thanks for your Help!!!!