Hello the community,
my table has a list of projects (one line per project) with monthly income and a number of months, thus calculating the yearly income per project (one column for monthly amount and one column for number of months) and per year if i sum all the lines.
i am trying to create a view so I can visualize (in a dashboard) my forecasted revenue per month that includes all projects. The problem is that my table does not provide in which specific months the monthly revenue applies.
I also have a column with project start date and a column with project end date but I am not sure how i can use it to capture a monthly revenue per project.
i hope my explanation is clear enough.
Thank you in advance for your help!