I have a specific problem. I have a big table that collects transactions in each row and saves the date for each one. I want to be able to know the total amount of all transactions inside a certain period (for example, a specific week of the year or a month for instance).
I do know I can do a “IFROLLUP” in a way filtering on different columns certain conditions. However, since the weeks of the year or months of the year will stack up over time in a lapse of two years I would have to make 104 columns for each week in addition to 24 columns for each month. Adding the fact that I do not want to be adding columns for my app to work.
Is there a more ingenious solution to this?