Rank Function in straight table

[#1]

Hi,

I have a customer name selector on my report, the customer is single selected.

	Sales	Rank
Product 1	10	102
Product 2	122	14
Product 3	1341	14

The above table should show me the rank of the selected customer (among all customers for that product) for the different products.

Thanks,

Gaurav