COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: garydobson87 on 27 May 2015 03:46:19 AM

Title: Rank on two measures, duplicate values.
Post by: garydobson87 on 27 May 2015 03:46:19 AM
Hi all,

I am trying to do a rank on product count, but where there is multiple first place items ( several products selling the same amount) I would like to identify the highest value item.

This is being presented using a mouseover flyout that shows the top ranking product with regard to items sold.

Any idea? It seems to be selecting them almost at random when we have multiple first place.

Thanks in advance for any help.
Title: Re: Rank on two measures, duplicate values.
Post by: Lynn on 02 Jun 2015 08:58:43 AM
Quote from: garydobson87 on 27 May 2015 03:46:19 AM
Hi all,

I am trying to do a rank on product count, but where there is multiple first place items ( several products selling the same amount) I would like to identify the highest value item.

This is being presented using a mouseover flyout that shows the top ranking product with regard to items sold.

Any idea? It seems to be selecting them almost at random when we have multiple first place.

Thanks in advance for any help.

If the amounts are all the same then they are all ranked the same. I believe this is known as Olympic ranking. How could it know which one to pick when the amounts are all the same? Is there any other criteria that would break the tie?