Trying to make a summary field (max date) with multiple related tables

I have the following relationships:
company<interests
ticker<interests

How do I display the latest interest (max date) for each ticker for each company?

I have the summary field for each, but they don't take the other into account.

Thanks!