4 Replies Latest reply: May 13, 2018 1:12 PM by beck bakytbek RSS

    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