There are two part to this query to get the results. The first to get the data in a format so you can easily pivot it to the results you desire
SELECT RecieptNo, s_adm_No, FHeadID, sum(Apr + May + Jun + Jul + Aug + Sep) as Fee FROM tblPivotTest group by RecieptNo, s_adm_No, FHeadID
union all
SELECT RecieptNo, s_adm_No, 'Total' as FHeadID, sum(Apr + May + Jun + Jul + Aug + Sep) as Annual FROM tblPivotTest group by RecieptNo, s_adm_No)
This puts the data in a format of
RecieptNo s_adm_No FHeadID Annual
1 1002 AnnualFee 500
1 1002 ScienceFee 600
1 1002 TuitionFee 350
1 1002 Total 1450
The second is to then add this new data structure to the pivot to get the results you desire
select * from (SELECT RecieptNo, s_adm_No, FHeadID, sum(Apr + May + Jun + Jul + Aug + Sep) as Fee FROM tblPivotTest group by RecieptNo, s_adm_No, FHeadID
union all
SELECT RecieptNo, s_adm_No, 'Total' as FHeadID, sum(Apr + May + Jun + Jul + Aug + Sep) as Annual FROM tblPivotTest group by RecieptNo, s_adm_No)
tblPivotTest pivot (sum(Fee) for FHeadid in ([TuitionFee],[AnnualFee],[ScienceFee],[Total])) as fee
RecieptNo s_adm_No TuitionFee AnnualFee ScienceFee Total
1 1002 350 500 600 1450