Sum within Set Expression

[Anonymous]

Trying to calculate the Count of IDs where sum of Sales by IDs should be greater or equal to 10,000.

Count({<WeekNum={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}, Aggr(Sum({<WeekNum={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}>} Sales), IDs)={">=10000"}>} IDs))

[Clever_Anjos · Accepted solution]

Count({<WeekNum={"<=$(vCurrWeek)"}, Year={$(vCurrYear)}, IDs={"=Sum(Sales)>=10000"}>} IDs))