Help in expression in pivot table?

[#1]

Hi,

I have below expression in pivot table

Count( DISTINCT{$<Product={'Soaps'},Delievery={'Postal'},Result={'Success'},Flag={1}>}ProductID)

I would need to change the expression whihc is like below

Product equal to Soaps but Delievery not equal to Postal

How can I change the avove expression? can anyone help me

Thanks.

[rustyfishbones · Accepted solution]

add a minus in front of -={'Postal'}

Count( DISTINCT{$<Product={'Soaps'},Delievery-={'Postal'},Result={'Success'},Flag={1}>}ProductID)}

[#3]

Thanks. Perfect