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.

Kevin

Added on Sep 3 2008

#bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee

2 comments

754 views