Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. .
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] )
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.