Sum of fields- report studio

[juffin]

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

[MFGF]

Hi,

Add Column2 as a query calculation with the expression

total([Col1] for report)

Cheers!

MF.