- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Using calculated item to calculate running balances

Subject: | Using calculated item to calculate running balances |

Posted by: | Laurence Lombard (lombar…@mweb.co.za) |

Date: | Fri, 3 Oct 2003 |

I have a Pivot Table of a cash book showing monthly transactions per account

as per example below.

A B C D

1 Acc Jan Feb Total

2 100 1000 500 1500

3 200 200 300 500

4 Total 1200 800 2000

5 Running 1200 2000

I would like to add a row at the bottom showing a running balance. This is

easy enough with a normal formula eg B5 = sum(B4,A5) and copied to the

right. This row gets overwritten if the pivot table expands downwards. I

would think adding a calculated item must work, but I do not know how. Can

someone help?

Thanks

Laurence

- Using calculated item to calculate running balances posted by Liz on Fri, 3 Oct 2003