Removing a pivot field in the Value Field - Macro - Pivot Charts

Hi There

Building on from this here – how do I remove the PivotField("#") from the Values field

The below macro basically goes through the 2 pivot charts and puts the pivot field “#” in the Values field in position 1

Now how do I reverse this and remove it

Please Login or Register  to view this content.

I have tried adding something like the below to remove it but I cannot work it out. Appreciate any help.

Please Login or Register  to view this content.

The below removes everything from the data field.

I want to modify it so it only removes the pivot fields I want removed.

How can this be done?

Please Login or Register  to view this content.