Filter member by "exclude" string - Analysis for Office

Hello All,

I am working on analysis for office 2.6. I have a requirement related to Filter the member. I want to filter my member based on Exclude string.

For e.g.

Dim lResult as long

lResult= Application.Run("SAPSetFilter",
"DS_1", "0SOLD_TO__0COUNTRY", "CA;US;DE", "New York")

Now I want to exclude this "New York" From my selection.

Please help

Regards

Parichay Gupta