Perhaps something like this?
var query =
from p in Products
group p by p.Category into g
select new { Category = g.Key, Total = g.Sum(p => p.Price), Values = g };
See it working:
http://ideone.com/ckhFNq
But it would be more efficient just to calculate the total with a for-loop.