I will not copy your whole query, just use the names...you add the query in the space below.
SELECT Total_Flag, USER_NAME, SUM(NOT_RESPONDED_COUNT), SUM(FAILED_COUNT), SUM(RESPONDED_COUNT), SUM(TOTAL_COUNT)
FROM
(your query above) qry
GROUP BY
TOTAL_FLAG, USER_NAME
You could add sums directly into your query, but with cases and COALESCE it could get unreadable (even more then it is) - also, try removing group by status and type in your query. Maybe even completely.
If this helps please take time to accept the solution. Thank you.