2 Replies Latest reply: May 28, 2012 5:40 AM by Simon Ainscough RSS

    Ranking a particular product



      I want to able to refer to the rank a particular Product within a table.


      Please use the attached qvw file.


      I have ranked my products in a table using:

      =Rank( Sum( Value ) )  


      and have been able to refer to the 1st ranked product using:

      =Only( {< Product = {"=Rank( Sum( Value ),Product )= 1" } >}           Product  )


      However I want to able to display the Rank of Product 'A' but cannot work out how to do it.


      Any help would be appreciated.