Hello,
I have read through lots of postings on this subject and don’t think there’s a solution but I thought I might post my question as a last resort.
I have a report where I am ranking the top sales persons by number of units sold over the past month. In most cases, there are duplicate “units sold” at place 10, 11, 12, etc., so the top 10 turns into the top 15. Is there a way to ONLY show the top 10 regardless of duplicate measure values? I have tried working in the Linenumber function with no success.
To borrow a golf term, Ranking in BusObj takes the Top X “and ties” … which makes sense to me. Let’s say you have 3 records tied for 10th. Which one do you want to keep? You somehow would need to work that additional criteria into your ranking.
If you are using Oracle you might also want to look at the Dense_Rank function - this would require your universe designer to add a Rank object to the universe.
Thanks Dwayne. I guess I was looking for an easy solution to a complicated issue :). I’ll consider your suggestion and try to formulate a more meaningful ranking.
(BOB member since 2002-09-19)
(BOB member since 2002-06-20)
Dont’ blame you for trying … the odds are probably similar to winning the lottery, but then some do win! 
(BOB member since 2002-09-19)