AnsweredAssumed Answered

Help Creating Report with Data from Multiple Related Tables

Question asked by jhowlin on Apr 14, 2012

Title

Help Creating Report with Data from Multiple Related Tables

Post

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?

 

 

Thanks so much!

 

Jason

Screen_Shot_2012-04-12_at_2.25.17_PM.png

Outcomes