how to display Grand Totals.

Hi

  In below query how to display Grand Totals.

DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX);

SET @cols = STUFF((SELECT distinct ',' + QUOTENAME(T2."U_A_M")
            FROM Opch T0 inner join Pch1 T1 on T0."Docentry" = T1."DocEntry"
	inner join Oitm T2 on T1."ItemCode" = T2."ItemCode"
	where T2.U_A_M <> 'NA'
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)')
        ,1,1,'')

set @query = 'SELECT itemcode, ' + @cols + ' from
            (
                SELECT T1."ItemCode",T1."LineTotal", T2."U_A_M"
    FROM Opch T0 inner join Pch1 T1 on T0."Docentry" = T1."DocEntry"
	inner join Oitm T2 on T1."ItemCode" = T2."ItemCode"
	where T2.U_A_M <> ''NA''
           ) x
            pivot
            (
                 sum(linetotal)
                for U_A_M in (' + @cols + ')
            ) p '


execute(@query)


 I want to display total of all items.

itemcode    Admin    Purchase    Sales    GrandTotal
3000740003    NULL    61628.000000    NULL    61628.000000
3000820001    NULL    NULL    141251.000000    141251.000000
3000740004    1000625.000000    NULL    NULL    1000625.000000
3000810002    1306931.800000    NULL    NULL    1306931.800000

                        

              2307557  61628	141251	       2510436
Thanks