17 Replies Latest reply: Sep 29, 2017 9:07 AM by Sunny Talwar RSS

    Sum 8 bottom values of expression, multidimensional

    Nikos Tsachalis

      Hello all,

       

      I am loading data on monthly basis and I have created a report with dimensions Resource, Date, Time. What I am trying to do is to report per Resource the sum of the 8 worst values of an expression that is calculated daily (let's call it Xpression).

      I am trying to calculate the sum of the 8 bottom values of Xpression monthly for every Resource.

       

      I have tried this (which will not do what I want since it will get the top 8 values) with no luck at all, it returns 0 values:

       

      =sum({<Resource= {"=rank(sum(Xpression),4,0) <=8"},Date>} Xpression)