Finding Last Attended Production?

Hi all -

Trying to figure this one out - we have a list of constituents made, and we need to know what the last production was that they attended.
Is this possible? Either using a report, or analytics? The closest thing I've found is the Attendance by Performance report, but involves a lot of cross-referencing in excel.

Any tips would be much appreciated! Thanks in advance!