He can use roll up to get the bottom total too like below but I am not able to sort it right as he want based on Grandtotal.

SELECT [SlNo#] = ROW_NUMBER() OVER(ORDER BY OrganizationName DESC),

OrganizationName, HumanResourse, Finance, HelpDesk, ITDevision, GrandTotal

FROM (

SELECT top 100 percent

CASE WHEN (GROUPING(OrganizationName) = 1) THEN ' GrandTotal'

ELSE ISNULL(OrganizationName, 'UNKNOWN') end as OrganizationName ,

--OrganizationName,

HumanResourse= SUM(CASE WHEN DeptName = 'HumanResourse' THEN Total ELSE 0 END),

Finance= SUM(CASE WHEN DeptName = 'Finance' THEN Total ELSE 0 END),

HelpDesk= SUM(CASE WHEN DeptName = 'HelpDesk' THEN Total ELSE 0 END),

ITDevision= SUM(CASE WHEN DeptName = 'ITDevision' THEN Total ELSE 0 END),

GrandTotal= SUM(Total)

FROM TblData

GROUP BY OrganizationName WITH ROLLUP

--COMPUTE SUM(Total)

) d