Print Page - Sum of fields- report studio

Title: Sum of fields- report studio
Post by: juffin on 17 Oct 2013 02:29:59 PM

Hi
I'm new to cognos. I have a column Col1 and want to sum the total for all records. I can achieve this using Sum function.But I need to repeat the Total in all the rows of another column.(Col2). How can we get the totals in each row in Col2 ?
say
Col1 Col2
3 10
2 10
4 10
1 10
Thanks
Jf

Title: Re: Sum of fields- report studio
Post by: MFGF on 18 Oct 2013 06:42:50 AM

Hi,

Add Column2 as a query calculation with the expression

total([Col1] for report)

Cheers!

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: juffin on 17 Oct 2013 02:29:59 PM