Filter member by "exclude" string - Analysis for Office

[hodrv]

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

[TammyPowlas · Accepted solution]

Try using the exclamation point in your syntax - see https://help.sap.com/viewer/b25c777a2c8c4e3da2f472cce24f289c/2.7.1.0/en-US/f2700b436c9b1014bf2c9a7eb...

[hodrv · Accepted solution]

Hello Tammy,

Thanks for addressing, but It is going to help me because the link you've given is for normal filter, I want to filter by Macro.

Thanks

[TammyPowlas · Accepted solution]

Hello - that was my intent; please try using the exclamation point as the operator for exclude