Hi, I have a table with all the movements of several products with its name, date and quantity.
I would like to organize it in a year base, monthly base and quarterly base.
e.g.: if the user select from the auto calendar (DATE.autoCalendar.Year) the year, i would like the total sum of all the movements in that year and before.
if the user select a year and a month (for example april 2021) i would like to see the total of all the movements from the start date untile the end of april 2021.
if the user select the second quarter of 2021, i would like to see the total of all the movements of the first and the second.
