Set expression - exclusion issue

[Emil_bros]

Hi,

I have a table with sales by customer and calendar day.

I need a set expression that, after I select specific date range, will display only "new customers" in selected date - in other words customers that generated sales in selected date range but not generate sales in not selected dates.  

eg. when selecting date 08.07.2022 only customer A should be displayed because customers B ad C already had sales in the past.

I think I need to use EXCLUSION operator here but not sure how entire expression should look.

Emil

[rubenmarin · Accepted solution]

Hi, it could be something like:

Sum({<Customer=E({<Date={"<$(=Min(Date))"}>} Customer)>} Sales)

[Emil_bros]

thank you, almost correct. Finally I have used following (based on your answer):

sum( {$<Customer = E({1<Date={"<$(=Min(Date))"}>})>}Sales )