I have three tables: contact, organization type, and memberships. See attached data model.
Contacts is connected to organization type
Every contact has one type of organization (private, non-profit, etc.)
Memberships are connected to contacts
Contacts can sign up for memberships each year (2015, 2016, etc)
I simply want a pie chart that summarizes organization types by membership year. Therefore, I want to create a pie chart based on memberships, but summarizing based on linked fields.
I've figured out how to create a table report very easily... see attached graphic.
From what I can tell, you can't construct pie charts from arbitrary fields in connected records. Is that true, or am I missing something major?