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.
Try Rank Function and then give filter based on which rank you want i.e. 4th, 5th, etc.
Hope this helps!
Regards