I resolved this issue not long for a project I was doing.
It took a bit of time to get it working the way I wanted, so I guess this is a good place to put the detailed solution I found to work for me.
This method will get a macro to select specific items from a pivot table filter. It will select only the items specified in the macro, making all others invisible.
In case none of the field items is found, the pivot will display nothing.
It will ignore errors if 1 or more specified items are not available on the current dataset, diaplaying the info only for the ones that are.
To get the macro to be activated by a cell value, you must insert something like this into the page code (Not in the module)
Right click on page and select "view Code). This will activate the macro above if the cell value in B5 is changed to 3
Bookmarks