How to limit top N when using 4 expressions and 1 dimension. ?

[Anonymous]

Hello comunity,

I have this straight table where I have 1 dimension (dm_emisor.identificador_bloomberg) and 4 expressions. I need to limit the top 20 order by "Total", I tried with RANK() and dimension limit and it is not working. .

[andrey_krylov]

Hi, Alejandro. Try to limit in Chart Properties, but you need then to make Total the first expression

And Rank() function in calculated dimension should be working

=Aggr(

       If(Rank(

            Aggr(

                YourExpression)

            , [Dimension])

            , 1, 0) <= 20 ,

      [Dimension] )

, [Dimension] )

[Sergey_Shuklin]

Hello, Alejandro!

PFA.

There are two ways how to achieve your request:

1. Using Rank() function (for keeping dimensions clean);

2. Using calculated dimension with hidden null-fields.