A report to show all projects active during a fiscal year

[Leslie_Tanner_Scott]

Hoping someone can help. I'm trying to create a report showing all projects that are and have been active during FY23.  The report would be displayed as a column chart displayed for each month of the year.  I hope I'm making sense. 

[Madalyn_Destafney]

Hi there, this is a fairly simple report.

You can create a project report filtered to project entry 'greater than equal' to start of your FY23. Add any other filters necessary.

Then add a grouping for project entry date > by month. You can only create a chart based on groupings. So after your grouping, go to the Chart tab and apply that grouping.

[Leslie_Tanner_Scott · Accepted solution]

Thank you Madalyn!

[Madalyn_Destafney]

No problem. I recommend please marking my answer correct to help others : )

[Leslie_Tanner_Scott]

I sure will!

[Kundanism]

Hi @Leslie_Tanner_Scott 

Madalyn is correct, in addition, you can also make filter whether required project entered in Y2023 or were active from earlier than 2023. 

Mvh

Kundan.