OWC 9.0 - Filter using Greater than operator.

[Chavi]

Hello All



I'm fairly new to OWC but have worked with MS OLAP to an extent.



I have to filter the data in a Pivot table (OWC 9.0) based on a
criteria.



I used Filtermembers property and it works when i pass the Unique value
in the member list

++++++++++++++++++++++++++++++++++++++



With PivotTable1.ActiveView.FieldSets("Age").Fields(0)

.FilterFunction = plFilterFunctionExclude

.FilterMembers = Array("25")

End With

++++++++++++++++++++++++++++++++++++++



But what i want to do further is to use ">" greater than operator in my
criteria. I wish to see only those who are greater than 25 years of age.



How do i achieve this in OWC 9.0 version.



Would be nice if anyone could answer my question ...



Chavi

 

[Dan Ricker]

Sorry, the > is not supported.