Count distinct new and old client

[Anonymous]

Hello,

I have a customer base on orders of 36 months of purchase.I wanted to know if we could from a period of date to verify if this same customer has already ordered over the last 24 months to know if It is a new or old customer to subsequently caculate a number of old and new customers

thanks for your help

[ahaahaaha · Accepted solution]

Hi,

May be like in attached file

Regards,

Andrey

[Anonymous]

Hi,

Thanks for your help

This is practically that but why does not it work when I select a date and more it is possible to get at the end only two figures. A separate discount from customers for old and another for new?

regards

[Anonymous]

Hello, I wanted to thank you for your help not looking with your track I found a solution

New client=>301 = Sum(If(Aggr(Min({<Date=>} Date), [Code Client]) < AddMonths(vDateDébut,-24), 1, 0))