4 Replies Latest reply: Mar 25, 2014 2:12 PM by Ajay Krishnan Prabhakaran RSS

    Monthly Running cumulative total


      Hi -

      I am new to Qlikview and I need help to calculate Running cumulative totals using a Pivot table as well as returning the MONTH (Index function in Excel) when a person actually reaches their Target (Sales Goal) for the year. I have been add Month 1 + Month 2 = Month 3, but there must be a better way to get the same thing using an expression.

       

      Please see attached excel file for reference.  I am trying to get A (cumulative months) and B (whether they meet Sales met their target, etc.)

       

      Please help..