Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
add a minus in front of -={'Postal'}
Count( DISTINCT{$<Product={'Soaps'},Delievery-={'Postal'},Result={'Success'},Flag={1}>}ProductID)}
add a minus in front of -={'Postal'}
Count( DISTINCT{$<Product={'Soaps'},Delievery-={'Postal'},Result={'Success'},Flag={1}>}ProductID)}
Thanks. Perfect