I would love to get some guidance on how to do something like a conditional roll up within one table.
If you see the table example below you can see that I have contractual start and end dates that I want to use as a guide for calculating Total Revenue so that I can calculate % of monthly revenue against the total revenue.
It is the TOTAL REVENUE column that I am having difficulty with as I don’t know how to make the calculation conditionally based on the contractual year that a particular month falls within. And as you can see, a contractual year may differ from calendar to financial year.
Is there a way to do this?
Thanks in advance!