Hello
I want to count customer who's order only once in particular year. In 2019 customer5 order in once so count 1 in 2020 customer2 and coustomer3 order in once so count 2 and so on.
thanks.
I want to count customer who's order only once in particular year. In 2019 customer5 order in once so count 1 in 2020 customer2 and coustomer3 order in once so count 2 and so on.
thanks.
Sunday, December 01, 2019 | Customer1 |
Sunday, December 01, 2019 | Customer5 |
Tuesday, January 01, 2019 | Customer1 |
Sunday, March 01, 2020 | Customer1 |
Sunday, March 01, 2020 | Customer2 |
Sunday, March 01, 2020 | Customer1 |
Sunday, March 01, 2020 | Customer3 |
Saturday, January 25, 2021 | Customer4 |
Tuesday, February 25, 2021 | Customer6 |
######################### | Customer4 |
Wednesday, April 01, 2021 | Customer3 |
Wednesday, April 01, 2021 | Customer3 |
Wednesday, April 01, 2021 | Customer4 |