Hey guys,

Thanks for your time. My problem is that I cannot figure out how to create a "running total" calculated field in an Excel pivot table. It is a large table and two of the columns are [Cost] and [Date]. I would like to create a calculated field that is a running total of my [Cost] column based on the date. Does anyone know how to do this?

Additional info:

This pivot table is being pulled in through a data connection, not a table so adding a new [running total] column to a table and then adjusting the range of the pivot table is not an option.

Side note- i am assuming there is a way to easily do this in excel (which I would prefer) but for those of you guys (or girls) who know SQL I am not opposed to adding a line of code to create a new column there for [Running total] if you know how to do that instead

--
JD