AX Report Wizard

Hi, I am trying to create a report which shows me Raw materials usage by item code over a perod of time. I am using Stock Transactions table but there is too much data for an excel file. I would therefore like to have the report totalled by item code but am unable to find a way to do this. Does anyone have any ideas please?