Share
ReportI need to see all customers that don't have a customer posting group of "INTERNATIONAL" I tried <> in the filter but it is not working.
You’re offline. This is a read only version of the page.
191
I need to see all customers that don't have a customer posting group of "INTERNATIONAL" I tried <> in the filter but it is not working.
Hi, just adding some info.
Entering Criteria in Filters (Not equal to multiple criteria)
Hope this helps as well.
Thanks.
ZHU
The Pipe option worked. I was using all caps. Not sure why it is not working. thanks for the help
one more suggestion - the filter is case sensitive so you must type it exactly how the posting group is. i.e. if your posting group is INTERNATIONAL the filter has to be <>INTERNATIONAL and not <>international or include spaces etc.
The <> did the trick for me. The following excluded Foreign.
Alternatively if there isn't a lot of Customer Posting Group. You can Include all except International.
And if this still doesn't work. Plan C. Export to excel and filter on the Customer Postng Group.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (