1 Reply Latest reply: Apr 5, 2013 3:20 AM by Kaushik Solanki RSS

    Previous YTD Financial Year

    Heri Zhang

      Hi all,

       

      Need for all your help,

      How to write expression with previous YTD in financial year (start from July end June)?

      So, if I click Month : Jan 2013, so it will sum from July 2011 until Jan 2012.

       

      I had success write YTD for current year with this expression :

      sum({<Month,FinancialMonth={"<=$(=only(FinancialMonth))"}>} Amount)  

       

      Thanks before.

       

       

      Regards,

      Heri