Summing Picked Item Qty & Cost per Line in Reports

Would it be possible to produce a report where each line in the report reads both a sum of the transaction qty and cost to aid with consignment reporting purposes? Currently when making a standard report, you cannot group by both Qty Picked & Total Value, and the report always displays each individual transaction per line. I'd like to be able to have an option where we can see a unique item per line, with a sum of the qty picked and total value of the picks, for a given date range.