Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Top 10 rows in a pivot table

615932May 18 2010 — edited May 19 2010
Hello,

I have an requirement to retrieve top 10 rows from the output pivot table.

Data on pivot table is structured as follows

Rows Measures
----------------------------------------------------------------------
"Name" "Grade" "Value North" "Value South" "Total Value"
----------------------------------------------------------------------
ABC A 100 200 300
BCD B 200 300 500

In the output there are 50 such rows and I want to display the top 10 rows with max Total Value.

Is it possible to achieve in OBIEE?

Any help is appreciated.

Regards,

Mukesh

Edited by: user612929 on May 18, 2010 12:38 AM

Edited by: user612929 on May 18, 2010 12:39 AM

Edited by: user612929 on May 18, 2010 12:41 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2010
Added on May 18 2010
#answers, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
7 comments
2,447 views