If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

TopCount equivalent to get 2nd, 3rd, 4th, etc. not top 2, top 3

Started by Stephaneky, 28 Jan 2018 05:24:12 PM

Previous topic - Next topic

Stephaneky

Hello,

Using 10.2.2 and I am trying to find a way to pick the 2nd, 3rd, ...10th best performer individually out of a list of 20. TopCount will give me the top N items, but what I want is being able to select the 5th, or 4th etc. in a dimensional model.

Nikhil Shenoy

Try Rank Function and then give filter based on which rank you want i.e. 4th, 5th, etc.

Hope this helps!

Regards