Row wise total in list report

[ajaju]

Hi All,

I have a report specification where there are several age buckets and in those buckets we have charges.
I need to have one more column that will add up all those charges row wise.

I have tried using separate dataitem and in the dataitem expression i have added all the respective age datatitems.By that does not works.Also had a try with query calculation but that also fails.Please let me know how to find balance amount for each row
e.g

Patient Name      (1-30)     (31-60)    (61-90)   (91-120)     Balance
aa                      $20         $30         $10         $20          $80
bb                      $10         $10         $10         $20          $50

Thanks in advance!

Regards,
Aarti

[actcognosuser]

If u are using a crosstab select the columns and use  the aggregation icon  in report studio ,select total.