I want o get total in the footer for this query
SELECT 'Total' AS Total, SUM([Coding]), SUM([Unit Testing]),
SUM([User Manual]), SUM([Meetings]), SUM([Testing])
FROM (SELECT TOP (100)
Name,
[Coding],[Unit Testing],[User Manual],[Meetings],[Testing],
TaskDate,
COALESCE([Coding],0) + COALESCE([Unit Testing],0) +
COALESCE([User Manual],0) + COALESCE([Meetings],0) +
COALESCE([Testing],0) AS Total
FROM (SELECT
TaskTitle As Title,
Hours,
Employee_Name AS Name,
TaskDate
FROM TimeSheet TS,
employee E,
Timesheetdetails TSD,
Task T
WHERE
TS.EmployeeID = E.Employee_EmpID AND
TSD.TaskID = T.TaskID AND
TS.TImeSheetID = TSD.TimeSheetID AND
T.Status='A' AND
TS.ProjectID = 43 AND
TSD.TaskDate >='09/26/2011' AND
TSD.TaskDate<='10/02/2011'
) up
PIVOT (SUM(Hours) FOR Title IN ([Coding], [Unit Testing],
[User Manual],
[Meetings],[Testing])) AS pvt
ORDER BY TaskDate DESC)
GROUP BY SUM([Coding]), SUM([Unit Testing]), SUM([User Manual]),
SUM([Meetings]), SUM([Testing])
but its showing error