Composite Rank

[Bonediggler]

Experts -

Is it possible to use the Rank() function on multiple values?

E.g. rank(distinct quantity, amount) as CompositeRank

I need the top 25 values and instead am getting about 70 due to multiple occurrences of the same rank - when only ranking on quantity.

Thank you!

[karthik.kadambi]

See if this works

http://www-01.ibm.com/support/docview.wss?uid=swg21336210