Excel 2003 Pivot Tables / Running Totals

[Debris]

Hello,

I have a dataset of expenditures for a project consisting of a date and an
amount. I want to produce a graph that shows spending per month, and a
cumulative total across the project -- which extends for multiple years (3,
to be exact).

I created a Pivot Table, with the date in the "Row" and the amount in the
"Data", and grouped by months and years. I then added a second "Data"
field, and chose running total.

My problem is, the running totals don't carry over and create a "Life to
Date" running total; they start over at each new year.

I'm sure there's a simple solution to this but I'm just not seeing it. Any
suggestions?

Thanks,

D

 

[Roger Govier]

Hi Debris

I don't think there is a way around this within the Pt itself, unless
you had another column in your source table that was cumulative values.

You could create an extra column to the right of your PT, with a formula
like
=C3+D4 (adjusted for your layout) and copied down the column.