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)
Regards,
Vikas