I want the report to show basically each project manager and how many days of work they have scheduled for projects during the current and following 3 months. The information I currently have to pull from is a start date, end date, and the total days for the project. Using a summary report showing any projects that are not complete and have an end date in the time period mentioned above, it just lumps all the days into one Month. For instance, if one manager has 4 projects that end in April that have a total of 50 days between them, the report puts all 50 days in April instead of breaking them down or the previous 2 months that they makes up those 50 days.
I am looking for a better way to set this up so that if a manager has 4 projects running from February to April totaling 50 days it shows that there are 10 days of work scheduled in February, 30 in march, and 10 in April.