5 Replies Latest reply: Jan 5, 2017 4:51 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