0 Replies Latest reply: Jun 14, 2017 10:59 AM by K K RSS

    YTD value from not regular calendar

    K K

      Hello Folks,

       

       

      I am facing an issue while deriving value for YTD. My scenario is like blow.

       

      Ex: Fiscal Year 2017 starts from July 1, 2016 and ends on June 30, 2017. So range of months is from July 16 to June 17.

       

      I need to get YTD value from start month to last moth which is value from start month July 2016 to May 2017 only.

       

      I can consider min(month_column) as start month but I am unable get value till last month dynamically.

       

       

       

      Can anyone help me out.