I need a pizza-like chart with 12 pieces where each piece is a month

I have a financial.dbf file with over 20,000 records

I would like to get the fields financial.price, and financial.date and create a sum by months

I tried to insert all data from this dbf but it resulted in an confuse chart
(maybe GDI graph does not create the query, only receives it ready ?

So, I would like a SQL code to create a small tempCursor containing: a field tempCursor.sum from financial.price
and tempCursor.month from financial.date

Then, I will send this cursor to the GDI graph



TIA