How to calculate running total + total remaining?

[MarceCastro]

Hello,

First of all, thanks you all for the great stuff you write every day. So...

I have this set of data:

I've built a pivot table and I need a column after RT (remaining total) to show how much money there's available each month until the end of the year:

Let's call that column "available yearly". This is how it would look like:

For January: $50 (available) + $5060 (budget from Feb to Dec)= $6010
For February: $50 (available) + $4610 (budget from March to Dec) = $4660

I have to say that RT is calculated a the running total of "Spend", so I can't using in calculated field.

Any suggestions?

Thanks!

PS. Just in case anyone needs the workbook, here it is.

 

[mart37]

not in your pivot table but in your data

Book1
	H	I	J	K
3	budget yearly	budget rt	budget remaining	available rt
4	5410	350	5060	50
Sheet1

Cell Formulas
Range	Formula
H4	=SUMIF([[ Year ]],[@[ Year ]],[[ Budget ]])
I4	=SUMIF(INDEX([[ Year ]],1):[@[ Year ]],[@[ Year ]],INDEX([ [ Budget ] ],1):[@[ Budget ]])
J4	=[@[budget yearly]]-[@[budget rt]]
K4	=[@[ Budget ]]-[@[ Spend ]]+IF(ISNUMBER(K3),K3,0)

 

[MarceCastro]

Thanks for your idea, but I need to find a way to do it in a pivot table. The table I used in my post is just a simple sample, but the real table is way bigger thant that. It has many fields and using regular calculations won't work (I need to be able to filter, use YoY calculations and so on)