help in calculation

Hi All,   I need you help/suggestion in acheiving the below result. my data has multiple rows for a product with same amount repeating. How would i show the category wise sum of amount but each pro...