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
<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!
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!