Rank in Dimensional Reporting

[cognos05]

one column has expression set(Product A, Product B,Product C, Product D, Product E).

So it will display like

Column A               Column B

Product A              Here I want the rep with highest sales on this product A
Product B              Here I want the rep with highest sales on this product B
Product C              Here I want the rep with highest sales on this product C
Product D             Here I want the rep with highest sales on this product D
Product E              Here I want the rep with highest sales on this product E

Say if there are two reps with same sales then that product will repeat twice in rows with two reps.
Ideally getting the reps with rank 1 for the product in the columnA .

TopCount(Rep,1,Product) will give only the top 1 , if there are two with same rank then how will get this working.

Please suggest me an expression for Column B to get the rep with rank 1 .

I am using this but I am getting the same rep for all the products
Filter([REPS],rank(currentMember([SampleOutDoor_Sample Cube].[Products].[Products])within set[REPS])<=1)

Thanks,
Nithya
 

[Francis aka khayman]

or are you also asking how to get the top rank rep or simply asking are you asking how to handle two reps with the same rank?

or both?

[cognos05]

Handling two reps with same rank, how do I get them for a set of products on column A.

Thanks,
Nithya