Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show the sales from the 20 first countries which sale horror movies, but I don't know how to anidate the function with set analysis to the set analysis.
Sum({1<Genero={"*Horror*"},Pais={"$(=rank(sum({1<Genero={"*Horror*"}>}Sales),1,1))<=20"}>}Sales)
i though with the dollar-sign expansion, but still doesn't works.
May be this
Sum({1<Genero = {"*Horror*"}, Pais = {"=Rank(Sum({1<Genero = {[*Horror*]}>} Sales), 1, 1)) <= 20"}>} Sales)
May be this
Sum({1<Genero = {"*Horror*"}, Pais = {"=Rank(Sum({1<Genero = {[*Horror*]}>} Sales), 1, 1)) <= 20"}>} Sales)