I have a table that has the following fields:
Fiscal Cal Period
Fiscal Cal Year
Begin Bal Qty
Period Change Qty

The issue is that this report only gives me the beginning balance for the first period in my selection.  I am picking all of 2011. 

Example
Period 1 - Begin Bal is 7000 - period change is 500
period 2  - Begin bal is 0 period change is 200
Period 3 0 begin bal is 0 period change is 800


Now the period change should be going towards the next periods begin bal so it should look like this.

Period 1 Begin Bal 7000
Period 2 begin bal - 7500
Period 3 begin bal  - 7700
Period 4 begin bal - 8500

But the problem is that it wants to add the period change to the current periods begin balanace so I get


Period 1 begin bal - 7500
Period 2 begin bal  - 7700
Period 3 begin bal - 8500

so it is actually off a period.

I hope this makes sense.  I'm sure I do some type of formula and use a -1 for the period for the period change data..... but I'm not sure how to do this......