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:





      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