Grouping Based on Total Purchases Under a Certain Amount

[kcfuiks]

Customer	Purchase Order	Amount	Shipping	Tax	Total
C001	P123	5.00	4.00	1.00	10.00
C001	P126	5.00	4.00	1.00	10.00
C001	P129	5.00	4.00	1.00	10.00
C002	P124	5.00	4.00	1.00	10.00
C002	P127	4.00	3.00	1.00	8.00
C002	P130	6.00	5.00	1.00	12.00
C003	P125	5.00	4.00	1.00	10.00
C003	P128	7.00	6.00	1.00	14.00

I’m stuck on this issue and could use some assistance.

I have a list of customers, orders they have placed, and the amount of each order. I need to flag customers that have spent a total of 10 dollars or less on an order *only* if all the orders that customer has placed are 10 dollars or less. So in this case, customer C001 should be the only customer flagged.

[gabrielvilella]

Hey @kcfuiks, you can do this by looking at the average and max value for the Total. If, for each customer, the average total and the max total are less or equals to 10, then flag.

[atcodedog05 · Accepted solution]

Hi @kcfuiks 

Here is my take.

Workflow:

Hope this helps : )

[kcfuiks]

@atcodedog05 Thank you!

[atcodedog05]

Happy to help : ) @kcfuiks 

Cheers and have a nice day!