Manage Resource / Crews by exception using Earned Value

We are trying to find a way to use P6 to filter to the resource / crews whose cumulative earned value units are less than their cumulative planned value units.

So in English, “show me the crews that are in trouble on the schedule” because they haven’t earned as many hours to date as we had scheduled to date.

I have attempted to pull this information out using P6 Reports, Exports to Excel, and Layout / Filter combinations, unfortunately, I either can’t get both Activity and Resource information in the same report / export, or I can get it in a layout, but then can’t filter to the summarized crews that are in trouble.