1 Reply Latest reply: Sep 20, 2017 3:18 PM by Romeo dela Cruz Jr RSS

    Cumulative Sum with two dimensions (Qlik Sense)?

    Romeo dela Cruz Jr

      Hi I have used the following formula to do cumulative sum on one dimension on a line chart:

      /accum = ,0,RowNo(Total)))

      accum = Rangesum(Above(

       

      when I wrap my measure with these like $accum(Sales)$(/accum) it works ok. But this works with only one dimension (Month_Number) in my chart. On a new line chart i need two dimensions: Month_Number and Region with Month_Number on the x axis. How can I fix or tweak my formula above? Thanks!