3 Replies Latest reply: Jun 13, 2014 4:33 AM by Satyadev Jaiswal RSS

    Prior Year (Rolling 12 Months)

    Valdi Alkitri

      Hi Guys,

       

      Can you help me guys..

       

      I've script Current Year :

      Sum({Year=, Month=, Date={">=$(=MonthStart (Max(Date),-11))<=$(=Max(Date))"}, [Field]= {'A','B'}>} Amount

       

      And How to write script for Prior Year (accumulation: rolling 12 Months).

       

      Thanks & Regards

       

      Valdi