how to bring a calculated field column total into next column ???

[#1]

Dear All

how to bring a calculated field column total into next column ???

for example

Column 1	Column 2	Column 3
Total	3,735.32	3,735.32
01/07/2012	461.60	3,735.32
02/07/2012	889.08	3,735.32
03/07/2012	621.45	3,735.32
04/07/2012	12.76	3,735.32
05/07/2012	623.03	3,735.32
06/07/2012	673.71	3,735.32
07/07/2012	350.21	3,735.32
08/07/2012	103.49	3,735.32

column 2 is a calculated field the total value 3735.32

column 2 total should be come into column 3 as 3735.32, is it possible ???

[jonathandienst]

Hi

No, it do not believe that it is possible to read the total value from one column. You can recalculate the total by using an Aggr expression:

=Sum(Aggr(...the expression for column1..., ...table dimension(s)...))

Just place the column 1 expression and dimensions in the expression as shown.

Hope that helps

Jonathan