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)


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

      I have sorted the Pivot Table, with the expression:





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


      But when I attempt to use the Rank function:






      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