I was looking into joined reports and need some understanding of how the common fields are set.
I have a opportunity and Lead report types in my joined report. I also have one custom field in opportunity called lead source and i also have lead source in leads.
I dont see this field as a common field in the joined reports. How are the common fields determined?
Please refer: How Joined Reports Work
A field is a common field if it’s shared by all report types or if all report types share a lookup relationship to the field. These fields appear in the Common Fields area in the Fields pane, and can be used to group report blocks.