How do I group 2 attributes for line graph Splunk

[Rayzer]

I'm trying to do a line graph using this command:

source="filename.csv" sourcetype="csv" | stats sum(intake), values(gender) by academic_year

Output:

Rayzer_0-1642263301401.png

However, I want the total intake to show the total for each gender, male and female so that my line graph will look something like this: 

Rayzer_1-1642263427021.png

Thank you for the help!

[ITWhisperer]

source="filename.csv" sourcetype="csv" | stats sum(intake) by academic_year, gender

[Rayzer]

This works only in the visualization tab, but my line graph still does not look like the drawing above.

Rayzer_0-1642300830931.png

[ITWhisperer · Accepted solution]

Change stats to chart