Custom column to get totals of a particular category in an order

Hi,

We want to add a custom column to an already existing report to get totals for a particular category. So this column will show the subtotal for that items that are from the said category in an order.

How can we do this?

Thanks,