+ Start a Discussion
jingzojingzo 

Unable to use 2 fields for grouping in Joined Report

Hi, I have the following Custom Objects and Report Types

CustomObj1 has a Lookup field to Account and another Lookup field to Product
CustomObj2 also has a Lookup field to Account and another Lookup field to Product.

ReportType1 use CustomObj1 as the Primary Object with Account ID and Product ID added via Lookup in Fields Available for Reports section
ReportType2 use CustomObj2 as the Primary Object with Account ID and Product ID added via Lookup in Fields Available for Reports section
​​​​​​​
I created a Joined Report but the common fields is showing only for Product object when I selecting the 2nd Report Type.

What is missing in my report or is it not achievable?

Thank you.