Support the OR statement in R360 Object Associations

We have a need to have an OR statement supported when we go to the R360 and associate an object to the relationship. Perhaps what we are trying to do is just unique, however here it goes… We have an object (object A) for “deals” which has 2 different lookups to the relationship object. The lookups are based off of specific market offerings therefore different R360’s were created. Each R360 supports either the subscription or the transactional part of the deal at hand. 

What we would like to be able to do is maintain 1 object and be able to support reports on the different levels of the deal. IE, grouping by the subscriptionRelationship field will return multiple records and grouping by transactionalRelationship field will typically return 1 record. 

Currently to do that we would need to either break the table into 2 tables or duplicate the table so that we can have 2 separate R360 object associations because we cannot say:
subscriptionRelationship == GSID
OR
transactionalRelationship == GSID
In the current setup.

I’m sure there are other use cases for this but someone else would have to outline those.