COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: DRL on 29 Nov 2010 01:47:58 PM

Title: Grand Total for a report with repeater
Post by: DRL on 29 Nov 2010 01:47:58 PM
Hi

I have a report that contains a repeater in it.  I am trying to get the grand totals for the entire report at the bottom of the report. I have the data items calculated for the totals but they show up at each grouping instead of showing only once at the bottom of the report.

Any help is greatly appreciated.

Thanks,
DRL
Title: Re: Grand Total for a report with repeater
Post by: MFGF on 30 Nov 2010 08:41:42 AM
Hi,

How have you calculated the totals currently?  You could try adding a Query calculation for each total you need with syntax along the lines of

total([your measure item] for report)

Regards,

MF.