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.