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

    Ranking a particular product

      Hi

       

      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.

       

      Thanks.