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