AnsweredAssumed Answered

Charts and Sub-summary Data

Question asked by tomo17 on Sep 11, 2014
Latest reply on Sep 15, 2014 by tomo17


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.

Any ideas???