Re: Creating a summary report based on multiple columns

Do you have a Table of Team members. Ie, a table of unique employees and a relationship to the projects?

If so, you can make a summary field of the number if active projects where the Resource is the Team Lead 1. Then repeat for each position.