I need to exclude a specific range of products from a pivot table. Typical product no looks like "D0002456". If I want to exclude all products including a "D" in the number - what expression IF statement can I use.
You can add set modifiers to your expressions in your pivot table. For example sum(Amount) would become sum({<Product-={'D*'}>}Amount) to exclude Products starting with a D. If you want to use an if statement you can use something like =if(not Product like 'D*',sum(Amount))
