Help Creating Report with Data from Multiple Related Tables
Folks have been extremely helpful here, thank you!
I have a database with tables linked according to the diagram attached.
CUSTOMERS ulitmately own many TITLES. (They have ORDERS which have PRODUCTS which have TITLES).
I would like to create a report that shows for each title the number of customers that own the title. (And I've accomplished that). But then I want to show a breakdown for a group of customers that own a particular title, their distribution of ownership across all other additional titles (if any) below that. So something like this:
Title A1000 Customers Own
Title A1000 (100%) Title B200 (20%) Title C400 (40%) Title D100 (10%)
Title B300 Customers Own
Title A100 (33 %) Title B300 (100%) Title C200 (66%) Title D0 (0%)
Title C100 Customers Own
Title A... ...
Does anyone have any ideas how to approach this?
I guess I'm even having trouble figuring out which table to base the report off of. Is it titles, since I want to report about how many customers own each title? Or is it customers, since I want to group and summarize the number of customers that own a title?