create row and calculate column

Dear expert

I need your support to help me fix this . in my qurey
i have column has list of number as showing below

i need to to create a row to sum all column .... I couldn't do it with crosstab qry.

Credit Card Type SumOfCommission CountOfStatus
TAYSEER T12 CLASSIC 52 52
TAYSEER T12 GOLD 57 57

Thanks.

What's the result you like to see?

SELECT basic,hra,pf,SUM(basic+hra+pf) AS netsalary FROM salaryreport GROUP BY basic,hra,pf

basic hra pf netsalary
----- --- ---- -------
5,000 300 400 5,700
5,100 310 110 5,520
5,200 320 120 5,640
5,300 330 130 5,760
5,400 340 140 5,880

I hope this example helpful