Filter "between" or "begins with" with OLAP pivot table

[dj4n4]

I am trying to filter between two numbers. E.g. I need to filter the field to numbers between 100 and 200.

It seems like the OLAP pivot table filters like this, based on a recorded macro.

Let's say the existing values between 100 and 200 are 108, 112, and 198.

PivotTables("TableName").PivotFields("Field").VisibleItemsList _
= Array( "[Field].&[108]", "[Field]&[112]", "[Field]&[198] )

I don't know ahead of time what values will be between 100 and 200 so cannot list them all out. I need the code to be dymamic. Is there no way to do this?

Also trying to figure it out for "begins with" for strings.

Thanks.

 

[dj4n4]

To clarify, this is a vba question.

 

[dj4n4]

Hi.

Just following up. Anyone have ideas?