Calculate Rows and columns Total in pivot table in SQL Server

here is sql code for pivot table row and column total in gridview between two table with date parameter

USE [SilverProduction]
GO
/****** Object:  StoredProcedure [dbo].[Rags_itemwise]    Script Date: 05/31/2019 17:18:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER Procedure [dbo].[Rags_itemwise]
@StartDate Date,
@Enddate   Date

AS
BEGIN
declare @cols nvarchar(max);

SELECT  @cols= COALESCE(@cols + ',','') + QUOTENAME(contNo) from containerno;
declare @query nvarchar(max);

declare @sum nvarchar(max);

SELECT  @sum= COALESCE(@sum + ',','') + ('sum('+QUOTENAME(contNo)+')') from containerno;

--declare  @sum nvarchar(max);

--select @sum =

SET @query =

N' with cte as (SELECT *,(select sum(Iweight) from conissuance where  DATEPART(DAY, EntryDate) =stat.ddate ) as total

FROM (SELECT ContNo,ConIssuance.IWeight,

DATEPART(DAY, ConIssuance.EntryDate)as DDate

FROM ConIssuance

 inner JOIN Containerno on Containerno.CID=ConIssuance.CID
 where ConIssuance.EntryDate BETWEEN @StartDate AND @Enddate
)prd

PIVOT (Sum(IWeight) FOR ContNo IN (' + @cols + ') )AS stat)

select * from cte

union all
select 0,'+@sum+', (select sum(iweight ) from conissuance ) from  cte

'
exec sp_executesql @query, N'@StartDate datetime,@enddate datetime', @StartDate=@StartDate,@Enddate=@Enddate
end