Join Credit Real time and Participant Detail Subject area using Credited participant

Hi everyone,

We have a requirement to include participant detail-level fields in a report for the Credited Participant.

However, by default, the Credit Real Time subject area uses the Directly Credited Participant to join with the Participant Detail subject area.

Is there a standard workaround, a logical table join, or a specific configuration to change this behavior so we can pull details for the actual Credited Participant instead?

I have attached the actual vs. expected output mockups below to show exactly what we are trying to achieve.

Thanks in advance for your help!

Actual Results:

Transaction Number	Directly Credited Participant