Sum Rank filter

[lomi89]

Hello,

I developed this formula where I can sum TOP 20:

Sum({<id={"=Aggr(Rank(Sum( sales)), id)<=20"}>} Total sales)

After that, I would like to extract how many IDs have a condition, for example: ID's status = 'YES'.  And the result is 7 for 20.

Thank you very much,

Roberto.

[Bunim · Accepted solution]

Count(distinct {<id={"=Aggr(Rank(Sum( sales)), id)<=20"},status ={"YES"}>} id)