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...