Hi all,
I can't find the answer to this so hoping someone can tell me how. In a nutshell, I need to use the result from one column (month) as the starting point of the next column's (month's) calculation. As in, a rolling subtotal of activity from one month to the next.
I cant find how to write a calculated item or field using the previous period. The table below is an example. I need the 1,150 to begin the next column, the 900 to begin the next, etc.
Any ideas??
[/URL][/IMG]
Thanks very much!!!!![TABLE="width: 262"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 2"][/TD]
[/TR]
</tbody>[/TABLE]
I can't find the answer to this so hoping someone can tell me how. In a nutshell, I need to use the result from one column (month) as the starting point of the next column's (month's) calculation. As in, a rolling subtotal of activity from one month to the next.
I cant find how to write a calculated item or field using the previous period. The table below is an example. I need the 1,150 to begin the next column, the 900 to begin the next, etc.
Any ideas??

Thanks very much!!!!![TABLE="width: 262"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 2"][/TD]
[/TR]
</tbody>[/TABLE]