SQL Pivot Query Total in Analytics

Hi everyone.

I have designed a pivot query which works and I have tried to add a total column but it shows as empty.

Here is my code:

SELECT

"Pvt"."Request Display ID" as "Request_Display_ID",

"Pvt"."Open" as "Open",

"Pvt"."Awaiting User Info" as "Awaiting_User_Info",

"Pvt"."Resolved" as "Resolved",

"Pvt"."Cancelled" as "Cancelled",

"Pvt"."On Hold" as "On_Hold",

"Pvt"."Closed" as "Closed",

"Pvt"."Pending Approval" as "Pending_Approval",

"Pvt"."Approval Not Received" as "Approval_Not_Received",

"Pvt"."Open" + "Pvt"."Awaiting User Info" + "Pvt"."Resolved" + "Pvt"."Cancelled" + "Pvt"."On Hold" + "Pvt"."Closed" + "Pvt"."Pending Approval" + "Pvt"."Approval Not Received" as Total

FROM

( SELECT

"Request Display ID",

"Status",

"Timespent in Minutes",

"TimeSpent_Hours"

FROM "StatusHistory_PivotData"

) AS SD

PIVOT

(SUM("SD"."TimeSpent_Hours") FOR "SD"."Status" in ( "Open" , "Awaiting User Info" , "Resolved" , "Cancelled" , "On Hold" , "Closed" , "Pending Approval" , "Approval Not Received" )

) AS Pvt

Is there something that works differently in Analytics than it does in SQL?

What am I missing?

Thanks

Aaron