27 Replies Latest reply: Aug 22, 2018 2:25 PM by Sunny Talwar RSS

    Line Chart: running total with multiple dimensions (month, year)

    Vicio Giglio

      Dimension1: Month

      Dimension2: Year

      Measure: Eur_commission (amount)


      I can calculate running total with 1 dimension only (month) using the formula:


      Rangesum( Above(Sum(eur_commission), 0, RowNo()))


      Screen Shot 2017-01-05 at 13.50.14.png


      If I add the second dimension (Year), the top chart (no running total) is perfect, the bottom chart (running total)

      doesn't work anymore.


      Screen Shot 2017-01-05 at 13.50.50.png