Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this expression. I need to show the bottom 10 instead of top 10…
=Sum({<[fecha.Cal.AñoMes] = {"=Rank(Sum([$(=vVarv)]))<=10"},[Calidad]={PRI}>} [$(=vVarv)])
Thanks.
Hello, does this function work?
=Sum({<[fecha.Cal.AñoMes] = {"=Rank(-Sum([$(=vVarv)]))<=10"},[Calidad]={PRI}>} [$(=vVarv)])
I simply add - in front of the Sum of the rank
Try adding a minus '-' after Rank function.
Sum({<[fecha.Cal.AñoMes] = {"=Rank(-Sum([$(=vVarv)]))<=10"},[Calidad]={PRI}>} [$(=vVarv)])
Thanks, with the minus - the page is blank, nothing showed…
Thanks for your reply, it is not working.
Try with this dimension
=aggr(if(rank(-Sum({<[Calidad]={PRI}>}[$(=vVarv)]))<=10,Dimension),Dimension)
Hi,
What's the data in this field? Can you be more specific, mentioning what bottom 10 details u need?