I have one table that has these fields
"client", "show" and "Jobs"
I have 38 unique clients, each has a number of shows, and many jobs under each unique show
Client "A" has 5 shows, different amount of unique jobs under each show
Client "B" has 1 show, many unique jobs
I want to create a layout that will list each client and how many shows that the client has:
It would look like this:
Client A; Show Name A; Jobs: 10
Client A; Show Name B; Jobs: 7
Client A; Show Name C; Jobs: 4
Client B; Show Name; Jobs: 15
Client C; Show Name; Jobs: 16
How would I do this?
Thanks in advance