i have 2 coumn in my rdlc
naration and amount as shown below
| naration |
amount |
| opening balance |
100 |
| closing balance |
100 |
| opening balance |
100 |
| closing balance |
100 |
| total |
400 |
in this the amount column is calculating all the record as total, which i dont want
i want to add the amount without taking naration as opening balance amount, rest all should be added as shown below
| naration |
amount |
| opening balance |
100 |
| closing balance abc |
20 |
| opening balance |
100 |
| closing balance xyz |
30 |
| total |
50 |
in above eg it added the cloumn without taking opening balance
can we write a expression in rdlc which will do the same.