Listing OWC9 PivotTable Row/Column Axis Filter Members

[Alan Stanton]

Does anyone know a way to figure out which members are currently
selected (filtered) on a row or column axis using a OWC9 PivotTable?
We are trying to iterate through a set of members, identifying which
ones are currently filtered (checked). I need something like

For i = 0 to j
With PivotTable1.ActiveView.RowAxis.FieldSets("blah").Fields("blah")
Debug.Print .FilterMembers(i)
End With
Next

In a related problem, the code

PivotTable1.ActiveView.RowAxis.FieldSets("blah").Fields("blah").FilterMembers
= Array([3],[4])

will properly filter to display only items [3] and [4], but you drop
down the list, nothing is checked, including [3] and[4]. Is this just
a OWC9 "feature"? Why aren't members properly checked when the filter
is applied using code?

Thanks in advance.

 

[yvonne de Vries]

I have exact the same question. How can you retrieve the
actual value of a member?
I hope anybody can give an answer.
Thank you
Yvonne