Using calculated item to calculate running balances

Giganews Newsgroups
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

Replies