Need report that shows all approval assignees who have NOT approved invoice

Summary

We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)

Content

We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet).  Unfortunately the report we built shows all past and present “assignees” rather than just providing the “open/incomplete” approvals.  I’ve attached some screenshots as well as an archive of the analysis we built.

I am no OBTI/SQL expert but is there a quick a simple way to return only the “most recent” assigned value in the data set for a particular invoice?  Interestingly enough if we go to BPM, look up the invoice and sort by “Assigned” it correctly returns only the INCOMPLETE (unapproved) pending approvals which is out desired result.