Count of Customers per cashier a month

[Toya2323]

I've been stuck on this for a while.  I need to display it in table

How many cashiers saw one customer per month?  Answer: June - 4, July - 2

How many cashiers saw more than one customer per month? Answer June - 2, July - 3

[maxgro · Accepted solution]

How many cashiers saw one customer per month?  Answer: June - 4, July - 2

How many cashiers saw more than one customer per month? Answer June - 2, July - 3

I tried with

SUM(Aggr(IF(count(distinct Customers)=1,1,0), Cashier, Date))

SUM(Aggr(IF(count(distinct Customers)>1,1,0), Cashier, Date))

my answer: June - 4, July - 2

my answer June - 2, July - 2 (your answer is 3)

[Toya2323]

Thank you