Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD value from not regular calendar

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.

0 Replies