Pivot calculation from one Column to the Next

[StuartM1]

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]

 

[StuartM1]

Any ideas? Thank you!!!

 

[StuartM1]

Any ideas on how to create a calculated item or field using different columns in a pivot? Or, should i just set up a table below the pivot with calculations? Sorry, i wont keep asking, i just want to explore any options.

Thanks all!