Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ???
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