Pivot tables - calculated fields, cumulative of another field

[astrbac]

Hello all,

I am having what seems to be a trivial issue - how to add a calculated field to an Excel pivot table, a field which keeps the running total (or cumulative) based on some other field?

Example:

----
Total plan: 400
days: 4
----

Day 1. Daily plan: 100; Cost: 90; Running total (cost): 90;
Day 2. Daily plan: 100; Cost: 80; Running total (cost): 90 + 80 = 170
Day 3. Daily plan: 100; Cost: 90; Running total (cost): 170 + 90 = 260
Day 4. Daily plan: 100; Cost: 110; Running total (cost): 260 + 110 = 370

Day	Daily plan	Daily cost	Cumulative cost	Cumulative remaining
1	100	90	90	310 (400-90)
2	100	80	170	230 (400-170)
3	100	90	260	140 (400-260)
4	100	110	370	30 (400-370)

<tbody>
</tbody>

I need to be able to track and predict budget expenditure and adjust on a daily basis so that on the last day all the budget gets spent.

many thanks for all replies!