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

[#1]

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

for example

Column 1	Column 2	Column 3	Column 4	Column 5
	23.10		3,735.32	0.00
01/07/2012	1,241.90	1,220.41	461.60	3,735.32
02/07/2012	1,250.23	1,220.41	889.08	3,735.32
03/07/2012	1,245.34	1,220.41	621.45	3,735.32
04/07/2012	1,223.99	1,220.41	12.76	3,735.32
05/07/2012	1,195.45	1,220.41	623.03	3,735.32
06/07/2012	1,194.46	1,220.41	673.71	3,735.32
07/07/2012	1,201.70	1,220.41	350.21	3,735.32
08/07/2012	1,210.24	1,220.41	103.49	3,735.32

column 4 is a calculated field

column 4 total should be come into column 5 is it possible ???

[swuehl]

What be good to know some more details (exact expression used in Column 4, dimensions used, maybe also some details about your data model if relevant).

You could try using TOTAL qualifier with an aggregation function. For example, if your Column 4 expression is just

=sum(Value)

and shown here grouped by Column 1 as dimension (Date),

=sum(TOTAL Value)

used in Column 5 will give you the total value in all lines.

[#3]

=sqr((SUM(DOBVALUE)/100000)  -

(sum(total DOBVALUE/100000)/(count(total DOBVALUE)/count(total BRANCHID))))

in column 4 i used this expression

[swuehl]

If you need the expression total, I think it could be like

=sqr((SUM(TOTAL DOBVALUE)/100000)  -

(sum(total DOBVALUE/100000)/(count(total DOBVALUE)/count(total BRANCHID))))

If you need sum of rows, it could be

=sum(TOTAL aggr(

sqr((SUM(DOBVALUE)/100000)  -

(sum(total DOBVALUE/100000)/(count(total DOBVALUE)/count(total BRANCHID))))

, YOURCHARTDIMENSION))