I'd like to make a "reset" button that, when clicked, resets the view of my pivot table so that all of the filters have all of their elements selected (I mean the built-in filters accessible by clicking that little arrow next to every column header). The following line does this:
PivotTable.ActiveView.DataAxis.FieldSets(0).Fields(0).FilterMembers = Array("all")
(then repeated for each column, ^ incrementing the value above)
When I test this by changing the selected members for just one column, then click the button that this is bound to, the table does display all values (from whatever it was displaying before) but when I click to see which elements are selected (it should be all of them), none of them are actually checked. This is problematic for the rest, since I have to be able to reset the filters for each column for this to work. Also, if filter members are modified for more than one column, clicking the button does nothing at all. At the moment, I'm guessing that I'm only manipulating the end result, and not the actual check boxes. Does anyone know how?Thanks for any help.
PivotTable.ActiveView.DataAxis.FieldSets(0).Fields(0).FilterMembers = Array("all")
(then repeated for each column, ^ incrementing the value above)
When I test this by changing the selected members for just one column, then click the button that this is bound to, the table does display all values (from whatever it was displaying before) but when I click to see which elements are selected (it should be all of them), none of them are actually checked. This is problematic for the rest, since I have to be able to reset the filters for each column for this to work. Also, if filter members are modified for more than one column, clicking the button does nothing at all. At the moment, I'm guessing that I'm only manipulating the end result, and not the actual check boxes. Does anyone know how?Thanks for any help.
