I have 2 dates. data from date1 may continue to fall in to next year of date2 along with that yr data. Now, User want to compare only date1 Year corresponding to date 2 year alone data. 3 YoY, 6YoY etc.,with out any age differences for the data, How can I achieve it?
I can bring corresponding data by comparing year(date1)=year(date2) for excluding overlap of data for next ers from previous yr. But, For eg: date2 (month) &3 YoY selected for each and every year corresponding to date2(month) is start date for 3 YoY should be the output. It should be bar chart with sum for every year 3yoy
