Planned vs Actuals by Job Role on completed projects

All, Needs some guidance on this one. I'm trying to write a report that pulls by job role the planned hours vs the actual hours logged on all the tasks in a project. I'm able to create a view that pulls in these values, but the issue that I'm having is if there are multiple job roles on a task, the hours show under the first job role. Any thoughts would be great. Thank you, Marc Marc Mattaroccia Renown Health