This content has been marked as final. Show 4 replies
I have created this rank column and give hard coded value so that the display are sorted out according to the rank. The requirement is a bar chart sorted according to the rank. I do not want to display the rank numbers in the chart. If i exclude this field, the bars are not sorted out.If i include this field, the bars are sorted out , but additional values like 1,2,3,4,5 are displayed in the chart though in the criteria table--column format I have check hide as column properties not to show the values. It works perfectly in table, pivot table but not in charts. I am using 18.104.22.168.4 version.
Edited by: 872073 on May 14, 2013 8:54 AM
The below is the Oracle note from http://docs.oracle.com/cd/E21764_01/bi.1111/e16452/apndx_ui_chngs.htm
Measure-based sorts are not implemented completely for pivot tables and graphs in 11g. Graphs do not provide user-interface elements to emulate measure-based sorts. This is a restriction in 11g, and you can use workarounds to resolve sorting issues.
Try out Charts using Pivot table