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!

OBIEE chart sorting issue

user599926Jan 8 2009 — edited Mar 27 2011

Hi All,

I am trying to plot a graph in OBIEE which shows the person name ( X-axis) and total revenue earned by them on y -axis across the 4 qtrs of the yr. I want to sort the graph on highest revenue in descending order and for each person the vertical bar will be 2d stacked ( with Q1 on bottom of the bar.. q2.. followeed by q3 and q4). However when i order by Qtr .. the bars gets arranged randomly.. which means the person with the highest total might not be the 1st bar seen in the graph but gets moved to the middle.

How do i arrange the revenue total in descending order along with qtrs sorted on each bar. Any tips.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2011

Added on Jan 8 2009

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

15 comments

4,676 views