Datatable-rowwise and columnwise calculations

Question

Hi all...

 

 

I have a datatable as follows -

 

SrNo	Location	Total	Pending(A)	New(B)	Updated(C)	Remarks
1	Assam	4	1	3	5	Test
2	Bihar	7	2	4	6	Test

 Now, I want the output as follows -

SrNo	Location	Total	A	B	C	D=A+B-C	Remarks
						1+3-5=-1
						2+4-6=0

 And in the last row, I need column-wise total -

Total of Columns - Total, A, B,C,D.

 

Please guide...