SSRS - show row total in column

See more:

SSRS

reporting-services

hi,

I am working on SSRS 2008.

I have a report as follows, I want the toal of Amount in Total column. I am not able to get total in column. I have tried Add Total/Sum() features of SSRS but no luck.

+---------+-------+--------+-------+                                                                               |Supplier | Agent | Amount | Total |
+---------+-------+--------+-------+
|         | A10051| 237.2  |       |
| S2005068+-------+--------+       |       
|         |A10052 | 23.8   |       |
+---------+-------+--------+-------+