Using calculated item to calculate running balances

  • Thread starter Laurence Lombard
  • Start date
L

Laurence Lombard

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
 
L

Liz

Right click the Pivot Table, choose Table Options, click
on the Grand Totals for Columns.

Good Luck!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table, IF function, calculated item versus calculated field 1
Calculated Item causes undue repitition in pivot table 2
Problem with Calculated item in Pivot Table 1
Pivot Table calculated item 4
Pivot table - calculated item 0
How to show month end balances in a Pivot Table 1
PIVOT TABLE's Custom Calculated Fields 1
Calculated Item in a Pivot Table 2

Top