Top N for each grouping?
438410Sep 3 2008 — edited Sep 3 2008
Is there a way to show in OBIEE the Top N results for each group?
I want to show the top 10 amounts for each region in my table. If using a Top N filter, it returns the Top N overall results. I tried creating a pivot table and using 'Region' as the section separator, but got the same results. It's only returning 10 amounts total, and I want to see 10 amounts for each region.