Greater Than Less Than In One Set Expression

[Anonymous]

Trying to get Sum of Sales here Sales for each client is between 1,000 and 1,000,000

1. This one doesn't work:
Sum(Aggr(Sum({<Client={"=Sum(Sales)>=1000<1000000"}>} Sales) , Client))

2. This works partially, meaning also includes Clients with Sales lower than 1,000:

Sum(Aggr(Sum({<Client={"=Sum(Sales)>=1000"}, Client={"=Sum(Sales)<1000000"}>} Sales) , Client))

Any suggestions ?

Thanks.

[MK_QSL · Accepted solution]

=SUM({<Client = {"=SUM(Sales) >= 1000 and SUM(Sales) <= 1000000"}>}Sales)

[Anonymous]

Thank you.