5 Replies Latest reply: Jul 9, 2016 3:03 AM by Harish Kumar RSS

    Help in formula for Max of an axis

    Siddharth Sheshadri

      Hello,

       

      I have a stacked bar chart (snippet below) which has values ranging from 2 to 0. I have to limit the graph to show top 50 values and then if needed drill down into others.

       

       

      Right now, when I do that, the axis is changing to the max value of "Others" which I do not want. Is there some formula (I hope there is) so that we can set the max of the Y axis to the aggregate (in my example 2).

      Thanks in advance.

       

      Capture.PNG