Relating a field from one table to another for summary report

It's possible because my organization is using its own implementation of QB, not the cloud version. As such we have not upgraded to the current capabilities, so these 2 summary options are not available to us.

I'm not certain when the update will occur, until then I need to try to find a workaround to use indefinitely.