Calculate running total and grand total using Pivot in SQL Server

sir am getting records as below but i wants as i mention above

my sql query is

DECLARE @Sttudent_Id INT
SET @Sttudent_Id = 10003
 
SELECT * FROM
(
    SELECT [Subject],[Term],[Max_Marks],[Obt_Marks],[UploadDate] FROM Marks WHERE @Sttudent_Id = @Sttudent_Id
) as tbl
PIVOT(MAX(Obt_Marks) FOR [Term] IN ([1],[2],[3])) as PVT

i am getting  like

and i want

here is my stored procedure

CREATE proc [dbo].[sp_showmarks](@st_id int ,@result int output)
as
set @result=-1
IF( EXISTS( SELECT * FROM Marks WHERE Student_Id  = @st_id))
BEGIN
SELECT *
INTO #TempMarks
FROM 
  (SELECT Student_Id,Subject,Term,Obt_Marks
  FROM Marks WHERE Student_Id = @st_id ) as x         
     
DECLARE @DynamicPivotQuery AS NVARCHAR(MAX),@ColumnName AS NVARCHAR(MAX)
SELECT @ColumnName = ISNULL(@ColumnName + ',','')+ QUOTENAME(Term) FROM (SELECT DISTINCT Term 
FROM #TempMarks) AS [Terms]
SET @DynamicPivotQuery = ';WITH CTE AS(SELECT Student_Id,Subject,Term,Obt_Marks FROM #TempMarks )
SELECT Subject,'+@ColumnName+' FROM CTE
PIVOT (MAX(Obt_Marks) FOR [Term] IN('+@ColumnName+')) p 
ORDER BY Student_Id DESC'
EXEC(@DynamicPivotQuery)
drop table #TempMarks

 where i have to add  code for sum of rows and columns

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