Print Page - Rank in Dimensional Reporting

Title: Rank in Dimensional Reporting
Post by: cognos05 on 12 Feb 2015 05:01:31 PM

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

Title: Re: Rank in Dimensional Reporting
Post by: Francis aka khayman on 12 Feb 2015 07:38:20 PM

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?

Title: Re: Rank in Dimensional Reporting
Post by: cognos05 on 13 Feb 2015 07:45:47 AM

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

Thanks,
Nithya

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 12 Feb 2015 05:01:31 PM