Required Training vs Required Completed Training

Hello everyone,

I hope I can describe this to where it makes sense. I am trying to figure out the best way to approach the following scenario.

I have two tables, one that captures what an employee has attempted/completed with a completion status with the following (Completed, Not Completed, No Data) and the 2nd table shows a list of the Required training. But I also want to capture the completion status of all of the Required Training as listed by the agency and not just those training that was attempted/completed by an employee.

Another issue I am having is when creating a report/visual is that it only shows the actual number of employee that attempted/completed each training. But I also want to capture who hasn't attempted/completed each Required Training from the required training list.

Bottom line, is that I am more concern of the Not Completed or Not Attempted for each training to enable my agency to engage employees to completed those required training. And I am creating an Employee Training Dashboard to utilize as a tracker.

Is this possible?

Please assist and thank you in advanced.

All the best,

PRock