2 Replies Latest reply: Jul 20, 2017 4:43 PM by Michael Solomovich RSS

    Prior Year MTD and QTD Sales

    Mark Perreault

      Hi All

      I have the set analysis

      Sum({<Year=,Month=,DateKey={">=$(=Num(MonthStart(Max(DateKey))))<=$(=Max(DateKey))"}>}[Sales Amount])

      to calculate my Current Year month to date sales but want to now calculate my Prior Year MTD Sales and am having difficulty.


      Same with QTD.


      Thank you