June 15, 2016 at 11:26 am
#299
Ran into a user that wanted to exclude a specific product by product code instead of something like the original example (of all Categories with the word Fresh in them). Thought I’d post the syntax for that. Everything else is pretty much the same as the original post.
To exclude a specific product, by the product code or number (lets say the product code is 997653):
[Product].[Product].CurrentMember.name <> “997653”
Hope that helps!