In my data model I have the opportunity object with a lookup to a custom object called tenant.
I have another custom object called subs that also has a lookup to tenant.
How can I create a report that for each opportunity it will list information from the subs where it has the tenant in common?
I've tried creating a joined report with the following report types but have had no luck
- Opportunities and tenant
- Tenant with subs