Show bottom 10

[psettimini]

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.

[Clement15]

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

[Dataintellinalytics]

Try adding a  minus '-'  after Rank function.

Sum({<[fecha.Cal.AñoMes] = {"=Rank(-Sum([$(=vVarv)]))<=10"},[Calidad]={PRI}>} [$(=vVarv)])

[psettimini]

Thanks, with the minus - the page is blank, nothing showed…

[psettimini]

Thanks for your reply, it is not working.

[qv_testing]

Try with this dimension

=aggr(if(rank(-Sum({<[Calidad]={PRI}>}[$(=vVarv)]))<=10,Dimension),Dimension)

[muhammedraleen]

Hi,

What's the data in this field? Can you be more specific, mentioning what bottom 10 details u need?