2 Replies Latest reply: Jun 13, 2014 7:39 AM by Yang LU RSS

    Calculation Prior Year by selected Month

    Valdi Alkitri

      Hi Guys,


      Please help me..


      How to write script, if I want to see prior year by selected Month.

      for example:

      If I click Year 2014 and Month May then Summary Jun12-May13

      If I click Year 2014 and Month April then summary May12-Apr13


      and I've script YTD : sum({<YEAR=, MONTH=, DATE={">=$(MonthStart(Max(Date),-11))<=$(=Max(Date))"},[Field].


      Thanks for help.