Charts and Sub-summary Data
I am sure there is an easy way to do it but I have been working on it for a couple of hours for no joy. I need a new perspective.
I have a table of players that includes two fields - team and year of birth
What I want to be able to do is have a column chart that shows the number of each players for each year of birth in each team i.e.
red 1995 - 10, 1996 - 12, 1997 - 18
blue 1995 - 12, 1996, 14, 1997 -16 etc.
I have created a summary field that counts the number of year records and have been able to then use this to create a report showing this information sorted by Team then by Year of Birth
The problem comes trying to represent this in a chart form. I am only able to get the table showing by year of birth OR total by team.
I have tried setting up with y series, changing the sort order, the x axis data.