Calculate running total and grand total using Pivot in SQL Server

HI yogeshc,

Refer the below Test Query For your reference.

SQL

DECLARE @Sttudent_Id INT
SET @Sttudent_Id = 10003

SELECT * INTO #TempMarks
FROM (SELECT *
	  FROM (SELECT [Subject],[Term],[Obt_Marks]
	        FROM Marks WHERE StudentId = @Sttudent_Id) as tbl
            PIVOT(SUM(Obt_Marks)  FOR [Term] IN ([1],[2])) as PVT
) AS S

SELECT *,[1]+[2] as 'G Total' FROM #TempMarks
UNION ALL
SELECT 'Total',SUM([1]),SUM([2]), SUM([1]+[2])FROM #TempMarks
drop table #TempMarks

Output