Ranking a particular product

[#1]

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.

[Jason_Michaelides · Accepted solution]

Hi Simon,

Try:

=Only({<Product={A} >} Aggr(Rank(Sum(Value)),Product))

Hope this helps,

Jason

[#3]

Hi Jason

That works great, Thanks for your help

Simon