G
Gcook888
I found article KB 298046 says to use Office Web Components object model to
filter a PivotTable.
Use the IncludedMembers or ExcludedMembers property of a Field Object.
So they have a sample
Dim pField As OWC10.PivotField
Set pField = pFieldset.Fields("LastName")
pField.IncludedMembers = Array("Smith","Wesson","Eastwood")
I want to filter on a date range. For ex 10/31/01 - 12/31/01 and all possible
dates between the start and end dates may not be accounted for.
In other words I have
pField.IncludedMembers = ?
what ? would do it?
thanks
filter a PivotTable.
Use the IncludedMembers or ExcludedMembers property of a Field Object.
So they have a sample
Dim pField As OWC10.PivotField
Set pField = pFieldset.Fields("LastName")
pField.IncludedMembers = Array("Smith","Wesson","Eastwood")
I want to filter on a date range. For ex 10/31/01 - 12/31/01 and all possible
dates between the start and end dates may not be accounted for.
In other words I have
pField.IncludedMembers = ?
what ? would do it?
thanks