Need help to create a report that displays both CURRENT Projects and COMPLETED Projects for a specific month

[IsaDi]

Hello,

Has anyone created a report that shows both CURRENT Projects (Current Year) and COMPLETED Projects for ‘"This Month" (December)?

[Madalyn_Destafney · Accepted solution]

Hi there, you can do this in your filters of a project report. Have a set of filters for projects in current status within X timeframe and any other filters, then create another filter set within the same report using OR (not AND) and have your other set with projects in complete in Y timeframe (if you want to show completed in Dec, would do project actual completion in Dec), and any other filters with that. Then your report will show you all projects that fall within either filter set.

[IsaDi]

Thank you, @Madalyn_Destafney! 

That did the trick! I was grouping by Entry Date instead of Actual Completion Date.