Hi all, I haven't been able to find much on this through google. I have a pivot table that is filtered at a header level (i.e. not row or column) and this filter has multiple nodes to it. What I am trying to do is filter on a node 3 levels down and unfilter on a couple items within that node using VBA. Below is a simplified example:
Each node drills down to a more specific list. In this example I need a macro to select all results in Colorado and unselect Boulder
Node 1: North America, Europe, Asia
Node 2: Canada, US
Node 3: Colorado, California, Arizona
Node 4: Denver, Colorado Springs, Boulder
I feel like I have to address each node but I am unsure what the syntax for that is. Any help is appreciated.
Each node drills down to a more specific list. In this example I need a macro to select all results in Colorado and unselect Boulder
Node 1: North America, Europe, Asia
Node 2: Canada, US
Node 3: Colorado, California, Arizona
Node 4: Denver, Colorado Springs, Boulder
I feel like I have to address each node but I am unsure what the syntax for that is. Any help is appreciated.