Selection of year has to show previous year values
Hi,
I've below 3 years sample data in my app
Date
Sales
01/01/2020
100
01/10/2020
200
01/17/2020
300
01/18/2020
400
01/01/2021
500
01/10/2021
600
01/17/2021
700
01/18/2021
800
01/03/2022
900
01/12/2022
1000
01/17/2022
1100
01/18/2022
1200
No my requirement is if user selects year from the list box it has to show Current Year YTD - Previous Year YTD Sales. For example if user selects 2021 from year the sum of sales has to be 2021 - 2020 YTD Sales (i.e. 1200 ((700+600+500) - (300+200+100)) because today is 17th and sales has to show until 17th ), if user selects 2022 from year the sum of sales has to be 2022 - 2021 YTD Sales (i.e. 1200 (1100+1000+900) - (700+600+500)) and if user doesn't select any thing default values has to be current year (2022) sales (i.e. 3000)
