2 Replies Latest reply: Jul 13, 2011 3:40 PM by pmahamani RSS

    Avg of top 3

      Hi,

       

      I have a pivot table like this:

       

       

      Test
      Best (of 10 runs)
      Average (of top 3 out of 10 runs)

      1



      2

       

       

      My data is organized in the DB table like this:

       

       

      TestRun
      Value

      1

      1

      100

      12200
      ......
      110300
      2110

       

       

      I am able to calculate the best of 10 runs, using this expression - if(Match(Test,'1'),Max(Value))

      For average - this isnt cutting it - if(Match(Test,'1') and (Rank(Value)<=3),Avg(Value))

       

      Any ideas?

       

      Thanks,

      Pavithra