Most likely the problem here is that there are currently no completion records for the users who haven't started the course yet. You can see that there is a 0 in the "Number not started" column. So this report is saying there are 6 course completion records and they are all complete (that's where the 100% comes from).

If you have the setting "Course completion begins on enrollment" enabled in the course settings (the default), then a "Not started" record will be created at the time when a user is enrolled and this report should show you what you want to see.

This does require you to enrol all the users you want to report on to the course - otherwise there would be no way for the system to know who is required to take it.

Simon