Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ajaju on 11 Dec 2009 02:18:58 AM

Title: Row wise total in list report
Post by: ajaju on 11 Dec 2009 02:18:58 AM
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
Title: Re: Row wise total in list report
Post by: actcognosuser on 11 Dec 2009 08:39:41 AM
If u are using a crosstab select the columns and use  the aggregation icon  in report studio ,select total.
Text only | Text with Images