Sum 8 bottom values of expression, multidimensional
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: