Running total on percentages in Pivot table

[Wayne Dunlop]

TCDEN.jpg

Hi,
I have an external data source with some text fields, a month field, and two numeric fields :

• New customers per month
• New customer target per month.

I can get the external data connected to the spreadsheet and I know how to make Pivot tables.
What I can't manage is the running total of the monthly percentages as shown in the attached file TCEN.jpg.

(The picture is a fake PT. just to illustrate what I want to do but can't.)

Any help appreciated especially if it

• does not involve modifying the external data and
• does not involve VBA.

TIA,
Wayne