13 Replies Latest reply: Apr 26, 2012 10:51 AM by Richard Norris RSS

    Rank with an Avg column (Or only show first 5 records)

      Hi,

      I am attempting to only show the top 5 / worse 5 using an average.

      I have sorted the Pivot Table, with the expression:

       

       

      ((Avg(Price)-DefaultPrice)/DefaultPrice)

       

      This is also the definition of a column in the table.

       

      But when I attempt to use the Rank function:

       

       

      RANK(((Avg(Price)-DefaultPrice)/DefaultPrice))

       

       

      all values are 1.

       

      How can I restrict the table to only show the first 5 records, when using the order expression above?

       

      I am using v10