I have a pivot table that has names in the Row.
This PT is a source for a bar chart that needs to show each individual person in the bar chart (basically one bar).
I thought the best way to do this was to loop through the names and filter in the pivot table to show just the one person.
The code that is recorded doesn't want to work when I amend to use a string variable for the name
I am really struggling with this as it looks like it should be very simple but I can't find anything on the net to help.
TIA
This PT is a source for a bar chart that needs to show each individual person in the bar chart (basically one bar).
I thought the best way to do this was to loop through the names and filter in the pivot table to show just the one person.
The code that is recorded doesn't want to work when I amend to use a string variable for the name
VBA Code:
ptPivotTable.PivotFields("[My Accounts Region].[Proper Name].[Proper Name]").VisibleItemsList = Array("[My Accounts Region].[Proper Name].&[" & strPerson & "]")TIA
