This content has been marked as final. Show 4 replies
Do not select that column for any of the axis.
If not try to use Pivot table chart
Edited by: Srini VEERAVALLI on May 14, 2013 10:38 AM
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 126.96.36.199.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
Thanks a lot Srini!!
I could see two values in the view.One is graph and other one is pivot table.The graph is being sorted now.
Edited by: 872073 on May 14, 2013 9:07 AM