Check 1 item in the filter list opening the OWC - Pivottable

[Screaming Eagles 101]

Opening a page with a pivot table, we have a filter list where all
possibilities are checked by default.
Can we write code to check only the first item in the filter list ?

 

[Alvin Bruney - ASP.NET MVP]

Yes, you will need to get a reference to the filter axis and iterate it
accordingly

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[Screaming Eagles 101]

Any idea how to do it ?

 

[Richard Ch]

Maybe something like:
set fld = pivottable.ActiveView.FilterAxis.FieldSets().Fields()
fld.IncludedMembers = array(name)
set fld = nothing
Ta,
Richard

 

[Screaming Eagles 101]

Thanks !
Found this too and it works.
I have a filter on a column called MyDate
set ptview = ptable.activeview
ptview.FilterAxis.FieldSets("MyDate").BoundField.IncludedMembers =
Date() - 1