Static running total - don't change on filter

[Intoccabile]

Hi All,

Thanks in advance! I am looking for a way to have a running total in a pivot table be static. Meaning:

I have a pivot table generated from an external data source. I have created a running total from a few of the columns. I have a pivot chart based on the table with an S-Curve line generated from the cumulative values. However when I filter the starting months out of the chart/pivot the running total starts at 0 when realistically it should start at much more.

Is there a way to easily create a running total that calculates on all fields regardless of filter?

Thanks again!

Intoccabile