Total Sales within a year

Hello Experst,

I have developed a customized report which display all the Items Costs, On Hand Qty, 3 months usage, 6 months usage based on different warehouse and added a condition to display only certain product workgroup item.

Issue:
I want to display the last year (2024) total sales based on above condition.

Points:
As same as for 3 months usage and 6 months usage we have created a view

And same view i have tried for previous year but it is not working.

Any help.

Thanks in Advance.

Datascripts for 6 Months:
 

Code: