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

    Prior Year MTD and QTD Sales

    Mark Pererault

      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