This discussion is archived
4 Replies Latest reply: May 14, 2013 9:08 AM by 875076 RSS

hide the data in chart level

875076 Newbie
Currently Being Moderated
Hi All,

I have hidden the column in criteria in column format but still the values are displayed in charts. I am using this column for sorting only and do not want to display values . I have clicked the hide option in the criteria--column properties but the values are displayed in chart. In chart there is no option to hide this value. I am using case statement in column formula.

Is there an alternative way to implement the sorting based on this column in chart?

Thanks,

Sushil

Edited by: 872073 on May 14, 2013 8:39 AM
  • 1. Re: hide the column in charts
    Srini VEERAVALLI Guru
    Currently Being Moderated
    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
  • 2. Re: hide the column in charts
    875076 Newbie
    Currently Being Moderated
    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 11.1.1.6.4 version.

    Sushil

    Edited by: 872073 on May 14, 2013 8:54 AM
  • 3. Re: hide the column in charts
    Srini VEERAVALLI Guru
    Currently Being Moderated
    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
  • 4. Re: hide the column in charts
    875076 Newbie
    Currently Being Moderated
    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.

    Sushil

    Edited by: 872073 on May 14, 2013 9:07 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points