Sum for different months

[a_brancati]

Hello everybody! I have this kind of table

Months      Sales

January     50

January     60

Fabruary    60

March        100

March        10

March        30

I would like to a have a stacked column chart that shows the sum of sales per month. If I use sum (Sales) I'll have 310, instead I would like to have Jan 110, Fabr 160 etc.

Thank you very much!

[a_brancati]

Yes, thank you Aron, your example was very useful!

[Anonymous · Accepted solution]

OK so I thought about it for a second and made the attached which is what you want I believe.

This time it uses "Year" for the stacked bar and "Month" for the data segments