Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
I'll keep testing, but this seems to have done the trick! Thank you so much!