Help Needed: Data Grouping and Summation Issue

Hi all, i am facing issue in showing data with grouping with specific condition and also to show sum of values with the grouping data, can anybody help in this issue.