Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=SUM({<Client = {"=SUM(Sales) >= 1000 and SUM(Sales) <= 1000000"}>}Sales)
=SUM({<Client = {"=SUM(Sales) >= 1000 and SUM(Sales) <= 1000000"}>}Sales)
Thank you.