I am trying to count the number of orders having a certain caracteristic.
order 1
-----------
prod1
order 2
------------
prod1
prod2
order 3
----------
prod3
So I need the total number of orders containing prod1 or prod3. the answer from the above exemple is 3
TIA
I found a solution. Here what I did:
I created a calculated field "prodcount":
IF ([product] = "prod1" or [product] = "prod3")
THEN [product.id]
ELSE NULL
END
I then simply use cntd(prodcount)