Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Bonediggler on 11 Aug 2014 09:20:59 AM

Title: Composite Rank
Post by: Bonediggler on 11 Aug 2014 09:20:59 AM
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!
Title: Re: Composite Rank
Post by: karthik.kadambi on 16 Aug 2014 06:53:59 PM
See if this works

http://www-01.ibm.com/support/docview.wss?uid=swg21336210
Text only | Text with Images