I have a data model with a Table. In my data model, I have Record Numbers for two different sets of records. What I would like to do, is show a column whereby if the record number of Instance 1 in RecordSet 1 matches another Instance in RecordSet 2, then that record number is shown. Here is a screenshot of what I'm trying to do.
As we can see, in the srp_number column, we have matching dra_filenumbers. I would like to show these on the same row. My thought process led me to something like this which doesn't work.