Hello everyone,
Here is the following:
Table:
Load* Inline [
YEarMonthNum, Customer_Num_Sales, Income
2022-05, 25E, 350€
2022-06, 25E, 176€
2022-07, 26F, 140€
2022-08, 35E, 550€;
I want to create a script that can count the number of customer whose sales is superior to 150€.
But i have an issue is regarding the following:
in my examplen 2022-05 and 2022-06 the cusomer 25E is listed TWICE.
I want to do it for cumulative month.
So a new customer is a customer whose sales during the current period (may 2022) is superior to 150€ but in the last 12 months (not counting current months) the sales of this customer is zero.
I struggle counting only a customer once because i don't want to add duplicate.
Anyone can help ?
THanks
