3 Replies Latest reply: May 13, 2014 8:26 AM by Nizam HM Branched to a new discussion. RSS

    Stacked Bar Chart: Eliminate negative values from Total

      Hi All,


      I am trying to create a Stacked bar chart. My data has some negative valves.



      Total in stacked bar chart add the negative values instead of instead of subtracting it.


      Ex: Total should be 2913

      ie. Chock               Pen



      So for Mumbai sum of sales should be 2913.


      However my graph shows total as 3895. Besides that I dont want to show negative values in bar chart.


      If I do it with Pivot my Total comes correctly; if I apply stacked bar chart the values mess up.


      Any help or pointers in this regard are appreciated.