This appears to do the trick. Thanks so much @Doug Den Hoed‚ !

Looking for syntax (presumably in text mode) to add a filter to a task report to only display the minimum open task number for a project. Example: A Project has 5 tasks: Task 1 - CompleteTask 2 - CompleteTask 3 - OpenTask 4 - OpenTask 5 - Open I want to return only Task 3 (the lowest open task). In...

I have a report help request from an end user. They are trying to create a pie chart of # of projects grouped by current Milestone. Current Milestone = the earliest Milestone task in a Milestone path that's not yet at 100% complete. Example: There are 3 milestones in a path for each project (mile...