Exclusion between Alternate States

[ElsKnockaert]

Good morning!

I'm using 2 alternate states to compare 2 periods.

But I would like to have all the selected customers corresponding to one of my alternate states, that are not in my other alternate state. 

For example:

Alternate state 1 "Situation 1" : All active customers in July

Altnerate state 2 "Situation 2" : All active customers in August

I'd like to have a pivot table in which I can see all active customers in August that were NOT active in July. So excluding "Situation 1".

Does somebody know how I can do this?

[vincent_ardiet_ · Accepted solution]

You should be able to do something like this (if your alternate states names are "Situation 1" and "Situation 2"):

Count({"Situation 2"-"Situation 1"}  Customers)

[ElsKnockaert]

I'll keep testing, but this seems to have done the trick! Thank you so much!