Multiple objects and owners

Hello all. I am very new to HubSpot and the community and have been flying by the seat of my pants lately. I am currently trying to put together a report (pivot table) that houses multiple objects. Individually, the objects each have their own owner (leads and leads owner, etc), but in the pivot table they can be associated with a different owner (ie. leads and deal owner). The problem is that the different owners provide vastly different results (Leads and lead owner = 24 vs Leads and deal owner 123). I want to know if this is something that bacn be fixed with a custom object or custom property? I have created both but cannot seem to get them going properly. With my very limited knowledge, I feel that I may be approaching it incorrectly. Any assistance would be greatly appreciated.