7 Replies Latest reply on Mar 1, 2016 2:38 PM by ryan.angus

    Stacked column chart subtracting negative values

    ryan.angus


      I have a table with an amount field containing positive and negative numbers.  I'd like to create a stacked column chart, that doesn't put the negative values below the 0 axis, i.e. the absolute value of the negatives is stacked on top of the (positive values minus the negatives).  Wow, that sounds confusing, so I'll try and explain:

       

      Header 1Header 2Header 3
      Record 1income100
      Record 2expenditure-10

       

      I'd like the column to be stacked with income displayed as 90 and y displayed as 10.  Ultimately, the goal is to show the total value, with income as 1 colour and expenditure as another.  Hope this makes sense!