Rank on two measures, duplicate values.

[garydobson87]

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.

[Lynn]

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?