One way to go about this is to simply write your SQL to extract the data in the format you want, then display that on your Crystal Report.
eg:
select TypeID, TypeName, Sum(Amount) as TotalAmount
from VIEWNAME
group by TypeID, TypeName
order by TypeID, TypeName