Hi, we are created ytd and period over period calculation in sql server , we have 2014 and 2015 data in my data source
but we dont have 2016 data in my data source, as per requirement we need to show in the year 2016 also 2015 data and once data is updated into the
data source 2016 data it will be show 2016 data in YTD and 2015 data in YOY , other wise default data .YTD and YOY calculations are update dynamically as per updated data in SQL Server data based .
I don't see your question here other than you have a list of requirements you need help with. Do you have a specific issue or just need some light consulting time?