5 Replies Latest reply: Nov 22, 2010 8:20 AM by Gopinathan L RSS

    Total column in bar chart

    Jason Michaelides

       

      Hi All,

      I have a similar challenge (I think) to this one (http://community.qlik.com/forums/p/17002/145124.aspx#145124) and have tried to convert the answer for my needs but have failed so far!

      I have a table (Data) with many transactions, each with a Tx_Type (e.g. BUDGET, COMMITTED, REQ, PAID) and Amount. I'm trying to get to a bar chart that has the Tx_Type as the dimension with SUM(Amount) as the value. OK, this bit is obviously easy, but I also then need a final column that is Forecast. This is a sum of all Tx Types, except BUDGET.

      Can anyone help!

      Thanks in advance,

      Jason