function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Vidya BaskarVidya Baskar 

Creating report of two unrelated objects

Hi All,

I have two different custom objects Appliances and Electronics purchased by Customers(Basically Contacts).

Both the custom objects Appliances and Electronics are unrelated and they have customers(contacts) as look up field.

How to create a report of  Customers that purchased both Appliances and Electronics.

Please advise!!
 
Somya TiwariSomya Tiwari

Hello,

You can create a Joined Report for this scenario. 

  1. Electronics with Contact
  2. Appliances with Contact
Joined Report
Now you can join the report using the Contact: Last Name or Contact: Email
Group by Contact: Last Name

Hope this solves your problem. Please mark the answer as Best Answer if it solved your problem, this will help us to keep the community clean.

Regards,
Somya Tiwari