PivotTable: Adding Page Filters

[Phixer]

First, the code:

Please Login or Register  to view this content.

My problem is with this part here:

Please Login or Register  to view this content.

I need it to filter on anything beginning with 2613, not just 261302. Unfortunately, I do not know all the possible inclusions or I could just add them individually, so I need a wildcard to add to this filter and I have never done that.

Thus, I ask how to write a wildcard filter that will work in this pivottable.

Thanks!

[Phixer]

I am hoping for a more elegant solution, but here is one that works, in case anyone has a similar issue.

Please Login or Register  to view this content.

Commenting out the .CurrentPage filter from the beginning (it can be deleted, but I left it so you can see the difference from the previous post), I immediately have it sort through ALL the possible PivotItems and turn those that do not meet my criteria to not be visible (.Visible = False).

Still hoping for a better way to do it, but if nothing else, this works.