Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Count(distinct {<id={"=Aggr(Rank(Sum( sales)), id)<=20"},status ={"YES"}>} id)
Count(distinct {<id={"=Aggr(Rank(Sum( sales)), id)<=20"},status ={"YES"}>} id)