7 Replies Latest reply: Sep 30, 2016 9:28 AM by Robson Candeo RSS

    Minimum with Ranking

    Robson Candeo

      In this example, I neeed to find the minimum value considering ony the 10 bigger values.

      So where it shows 990, I need to be 1100 as this is the 10th bigger value

       

      My actual expression is:

      =Min(ALL Aggr(Sum({<Name=>} Value),Name))

       

      Thank You