Pivot Chart with Running Total

[krishna83]

Here is my Pivot table data.

[TABLE="width: 399"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Sum of total[/TD]
[TD="align: right"]Sales[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Month[/TD]
[TD="align: right"]Actual[/TD]
[TD="align: right"]Target[/TD]
[/TR]
[TR]
[TD="align: right"]Jul-15[/TD]
[TD="align: right"]1,041,824.00[/TD]
[TD="align: right"]1,043,486.13[/TD]
[/TR]
[TR]
[TD="align: right"]Aug-15[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]2,000,141.25[/TD]
[/TR]
[TR]
[TD="align: right"]Sep-15[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]3,013,169.74[/TD]
[/TR]
[TR]
[TD="align: right"]Oct-15[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]3,945,066.89[/TD]
[/TR]
[TR]
[TD="align: right"]Nov-15[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]4,914,635.34[/TD]
[/TR]
[TR]
[TD="align: right"]Dec-15[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]5,655,860.49[/TD]
[/TR]
[TR]
[TD="align: right"]Jan-16[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]6,391,296.91[/TD]
[/TR]
[TR]
[TD="align: right"]Feb-16[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]7,259,339.87[/TD]
[/TR]
[TR]
[TD="align: right"]Mar-16[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]8,180,282.95[/TD]
[/TR]
[TR]
[TD="align: right"]Apr-16[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]9,042,537.17[/TD]
[/TR]
[TR]
[TD="align: right"]May-16[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]10,002,576.48[/TD]
[/TR]
[TR]
[TD="align: right"]Jun-16[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]10,915,148.16[/TD]
[/TR]
</tbody>[/TABLE]

As you can see the Actual and Target (Sales) are cumulative totals. I got that using the show values as "running total in". My issue is data is linked to a pivot chart (line chart). My X axis is the month and Y axis is the Sales (two series - Actual and Target).
The chart depicts a linear increase for the Target which is right. For the Actuals, I want the chart to depict only Jul-15 and Aug-15 information.
In other words, I need pivot table not to calculate the cumulative sum for the months when the Actual value is 0. So I want my Pivot table to look like this.



[TABLE="width: 399"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Sum of total[/TD]
[TD="align: right"]Sales[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Month[/TD]
[TD="align: right"]Actual[/TD]
[TD="align: right"]Target[/TD]
[/TR]
[TR]
[TD="align: right"]Jul-15[/TD]
[TD="align: right"]1,041,824.00[/TD]
[TD="align: right"]1,043,486.13[/TD]
[/TR]
[TR]
[TD="align: right"]Aug-15[/TD]
[TD="align: right"]1,289,003.30[/TD]
[TD="align: right"]2,000,141.25[/TD]
[/TR]
[TR]
[TD="align: right"]Sep-15[/TD]
[TD="align: right"][/TD]
[TD="align: right"]3,013,169.74[/TD]
[/TR]
[TR]
[TD="align: right"]Oct-15[/TD]
[TD="align: right"][/TD]
[TD="align: right"]3,945,066.89[/TD]
[/TR]
[TR]
[TD="align: right"]Nov-15[/TD]
[TD="align: right"][/TD]
[TD="align: right"]4,914,635.34[/TD]
[/TR]
[TR]
[TD="align: right"]Dec-15[/TD]
[TD="align: right"][/TD]
[TD="align: right"]5,655,860.49[/TD]
[/TR]
[TR]
[TD="align: right"]Jan-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6,391,296.91[/TD]
[/TR]
[TR]
[TD="align: right"]Feb-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"]7,259,339.87[/TD]
[/TR]
[TR]
[TD="align: right"]Mar-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8,180,282.95[/TD]
[/TR]
[TR]
[TD="align: right"]Apr-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"]9,042,537.17[/TD]
[/TR]
[TR]
[TD="align: right"]May-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"]10,002,576.48[/TD]
[/TR]
[TR]
[TD="align: right"]Jun-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"]10,915,148.16

[/TD]
[/TR]
</tbody>[/TABLE]


And every month when the values in the Actual column are updated, the cumulative sum needs to be done and it should also reflect in the Pivot chart.

Any help is highly appreciated.

Thanks,
Krishna