Top 5

[beck_bakytbek]

Hi Folks,

i got a question: my situation does look like: one dimension and 1 expression

i am using: calculated dimension to show top 5:

=if(aggr(rank(sum(Preis)),Artikelnummer) <= 5, Artikelnummer, Null())

and my expression does look like:

Sum(Preis)

i want to show only Top 5, but i have a deviation and my table shows me the Top 7 (please see the attached screenshot)

my question: how can i force to show only Top 5 ?

Thanks a lot

Beck

[OmarBenSalem]

In ur dimension, limit it to the top 5 Beck; no need to use rank.

(and ps: it's because u have 3 dimensions that have the same value)

[beck_bakytbek]

Hi Omar,

thanks a lot for your feedback and help.

I know, i can limit my dimension via setting within table (for instanse: limit to 5). i wanted to know how to solve this issue with help of calculated dimension.

Thanks a lot

Beck

[sunny_talwar]

3 Articles have the same exact Preis... which one of the three would you want to show in the top 5?

[Thiago_Justen_]

What about this:

=if(aggr(rank(sum(Preis),3),Artikelnummer) <= 5, Artikelnummer, Null())

[beck_bakytbek]

Hi Thiago,

thanks a lot for your help and feedback