Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
My expression is
concat(Aggr(if(Rank(num#(OscarWon)) =1, title),title),'; ')
which returns the movies with the highest number of Oscars and if there are more than one, it concatenates them using ";".
My question is how I can ignore filter in this expression for all dimensions. I tried several set expressions but none of them worked.
Thank you so much and regards...
concat({1}Aggr(if(Rank(sum({1}OscarWon)) =1, title),title),'; ')
concat({1}Aggr(if(Rank(sum({1}OscarWon)) =1, title),title),'; ')