2 Replies Latest reply on Nov 7, 2016 8:33 PM by Nader H

    MTD Calculation as a running total

    Nader H

      Hey Community,


      Basically i'm trying to display MTD running total next to daily earnings, however, the (second) calculation doesn't include previous days of the month, only the displayed days. So i tried LOD expressions (third measure)  and managed to get the correct total for the entire month, however, i still need a method to display it as a running total along with days of the month.


      Would appreciate any input on this.


      First Measure: Daily

      Second Measure: Running Sum

      Third Measure: LOD Expression



      MTD Running total.png