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.

      Problem:

       

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

       

      Ex: Total should be 2913

      ie. Chock               Pen

      3895-982

       

      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.