I'm trying to show the worst 50 records based on Premium since I'm making a dashboard for an insurance company. I'm using union since that's a necessity in order to fulfill my requirement. The resulting reports shows more than 50 records i.e 60 records to be exact. It marks the same bottom position (a numeric value) to multiple records due to which it shows more than 50 records. Please let me know how to get rid off this problem. I'm using OBIEE 11g.