Category id and sum of total costs of purchases grouped by category id:

Category idSum of total costs of purchases
CA0011725.00
CA002965.00
CA003900.00