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