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.

       

      Regards.