Forum Stats

  • 3,839,160 Users
  • 2,262,458 Discussions
  • 7,900,875 Comments

Discussions

Top N for each grouping?

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
Tagged:

Best Answer

Answers

This discussion has been closed.