Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
Will appreciate.
Fanie
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))
hi
try this
=sum({<Product={"*"}-{'D*'}>}Sales)
if you have any doubt please refer the attachment
Thank you - I will try out.