Filtering custom groups?

J

jfizer

I'm trying to filter out the generated group "other" from my custom
groups. However, I get the message that "The value 'Other' is invalid
or ambiguous." when I try the following code. Any ideas or sugjestions
would be welcome.

document.pt.ActiveView.FilterAxis.InsertFieldSet(document.pt.ActiveView.FieldSets("Business
Unit"));
document.pt.ActiveView.FilterAxis.FieldSets("Business
Unit").Fields("Region").includedmembers=Array("Other")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
VBA to Find Word or Phrase then Highlight Entire Paragraph that Follows 5
Filtering by group in pivot table 0
Distributing custom themes? 1
OWC 10.0 Pivot - Trouble setting filter fields includedmembers property 3
"Compile error in table level validation expression " after format 0
how use IncludedMembers to filter multi-level dimension 0
VBA word change keys 0

Top