8 Replies Latest reply: Aug 29, 2018 6:04 AM by Andreas Jensen RSS

    KPI: Average of top 10 performer

    Andreas Jensen

      Hi,

       

      I'm currently doing a benchmark analysis and I have to find the average GrossResult of the top 5 performers.

       

      For example:

      CompanyIDGrossResult
      136,54
      2302,51
      329,71
      4103,02
      535,1
      6101,63
      732,76
      8352,64
      924,34
      10228,89

       

      Here I'm interested in finding the number 217,738.

       

      Does anybody have an idea how to do this in a KPI box?