Generating report

Dear Sir,

eg : i Have 3 customer “A” , “B” , “C” & have two products “AA” & “BB”

i want to generate a report to know about what total qty of product have been order by customer A,B & C within the time-span of 1month.

i want to understand what qty does my each of the customer consumes for the specified time period lets say 1 month.

for eg: A consumes 100QTY of AA, 50qty of BB