Thanks Guys It helped me lot.

Also I tried it to sortby Organizations since GrandTotal needs to appear on bottom

SELECT [SlNo#] = ROW_NUMBER() OVER(ORDER BY CASE WHEN ORGANIZATIONNAME = 'GrandTotal' THEN 'ZZZZZZ' ELSE ORGANIZATIONNAME END Asc),

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

) d