Filter for customers without orders

[#1]

Each week we load orders in the dashboard.   Weekly uploads are date stamped.

Not all customers will have orders each week but we would like to setup a filter

Customers with orders
Yes
No

We tried doing this in the script but the customer list is static so we cannot append a count or "Has orders" field because if we want to see a different week, the filter will change.

[sunny_talwar]

Can you provide some raw data and how you plan to use this filter?

[swuehl]

Try a list box with a field expression (select <expression> from the field drop down list on general tab) like

=Aggr( If(Count(OrderID)>0,'Yes','No'), CustomerID)

[#4]

I figured aggr would have to show up.  I used the expression but only now realized the expression effectively filters itself.  If I select Yes, No disappears and select No, Yes disappears.

[swuehl · Accepted solution]

=Aggr( If(Count({<CustomerID= >}OrderID)>0,'Yes','No'), CustomerID)

[#6]

Forgot about that clause.  Very nice - many thanks.