Need Help! Trying to track multiple project completions based on sub task statuses Ex attached|General Excel Questions & Answers|Excel Forum|My Online Training Hub

First, I like most must thank you for all of the great guidance you put on youtube it has helped me more than you would ever know!

My issue revolves around tracking not one project and its sub-task but hundreds with their own subtask. I queried all of the subtask statuses and paired them up with the main projects. I want to get my dashboard to count only the projects that are fully complete and the ones that still waiting on completion. 

I created a made up sample of what I'm looking at. Basically, the task is to be able to see how many of the projects are completed overall, and each project's progress. If you look at the attachment I feel like I am almost there but in the end when I create a table referencing the pivot table it doesn't work because it doesn't work with pivot table filtering. In the back of my head, there has to be a better way. 

I apologize if this is not in the scope of this forum but I'm going crazy trying to find away.