In reports how can we combine series fields.
Suppose there are 5 boys 5 Girls from a classroom A, Now if i want to plot a line chart on this data, i would get 10 lines of the students in the classroom.
What i want is to get 2 lines in chart for girls and boys.
How can i do this