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.