Summary Table
I am having difficulty getting my mind around this to even begin. I need to summarize the Revenue for a project: The Revenue Date can be a single, or multiple dates, and the Revenue Amounts can vary...
Forum Discussion
I am by far not the most experienced user here but I'll give you my thoughts. You said that all the dates and amounts are on a single record. If you mean that for each revenue line (from your image) those amounts are on a single record then I would ask what your field names are.
If your field names were generic (i.e. Jan, Feb, Mar, etc.) you should also have a Year field. So for each revenue line you would have multiple records (1 for each year) which could hold the values for each month of that year. Then it should be pretty simple to just filter your report to the specific year you are trying to report on (i.e. 2024).
Not sure if this helps or not.