**User-1496088595 posted**
Considering the below result is from your view/table.

typeoftransaction |
SrAccountant |
PM |
CSK |
CMC |
HoAdmin |
SAdmin |
CMD |

Term Loan Payment |
0 |
0 |
0 |
0 |
0 |
2 |
0 |

PF Payment |
1 |
0 |
0 |
0 |
4 |
0 |
0 |

Bank Payment |
0 |
0 |
0 |
0 |
4 |
5 |
0 |

Salary Payment |
0 |
0 |
0 |
0 |
0 |
0 |
0 |

then you can easily put this result in sub query and get your expected result.

Suppose **TempView **is your view/table which returning the above result.

SELECT typeoftransaction,

SUM(SrAccountant) as SrAccountant,

SUM(PM) as PM,

SUM(CSK) as CSK,

SUM(CMC) as CMC,

SUM(HoAdmin) as HoAdmin,

SUM(SAdmin) as SAdmin,

SUM(CMD) as CMD

FROM

(

select 'BANK PAYMENTS' as typeoftransaction, SrAccountant, PM, CSK, CMC, HoAdmin, SAdmin, CMD from TempView

)

GROUP BY typeoftransaction;