I want to add/remove Pivot Table Value Field item with a macro. Want to then assign the code to a button and when clicking the button the addition and removal should alternate.
Please Help.
I'd suggest recording a macro of yourself adding/removing said item from your Pivot Table. This will give you the code/syntax that you need to accomplish your task.