I need to pull a report that pulls info from 2 parent objects with the same child.
payment as both parents of
GAU Allocation. We need to access fields from
Opportunity, however the relationships are not mapping out correctly when creating a custom report type. In other words, GAU allocation is not an option when selecting a third object.
Payment is the child of opportunity,
GAU allocation is the child of
I have tried the following:
- Joined report: The rows are not matching to the right record in both reports
- Cross field filter: We do not need to filter, rather just display the
GAU Allocationfield on the report
Is this possible or even with SOQL?