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: How to sort a bar chart by a measure not displayed in the chart?

850717Mar 27 2011 — edited Oct 15 2012

I have a table with OEM sales volume comparisons between two periods, current year and previous year. I have calculated a "VOLUME CHANGE" measure by subtracting last year's volume total column from this year's volume total column, and would like to display the resulting VOLUME CHANGE column in a horizontal bar chart.

However, I want the bar chart sorted in descending order by the sales volume total column rather than the value of the calculated "VOLUME CHANGE" that is displayed.

Can someone help me make this happen?

In Answers I can make a bar chart sort according to any sort applied to a measure IF YOU INCLUDE THE SORTED MEASURE IN THE CHART, but I can't readily see how to do this if you wish to only include one measure in the chart but sort it by another measure from the same table.

Help would be appreciated.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2012

Added on Mar 27 2011

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

13 comments

9,955 views