Intersection between 2 alternates states

[#1]

Hi community,

I've got 2 alternates states based on a same dimension for a comparative analysis, it works fine. But now, I wanted to know how much values are in the two states, abd how much aren't in.

My two states are groupe_1 and group_2, so I've got these two expression : count({[groupe_unite1]} name) and count({[groupe_unite2]} name) .

So I want something like that : count({[groupe_unite1],[groupe_unite1]} name) and count({NOT IN ([groupe_unite1],[groupe_unite2])} name).

Is it possible?

Thanks for your answer,

Mickaël.

[#2]

count({$<groupe_1={'groupe_unite1','groupe_unite2'}> name)

and

count({1-$<groupe_1={'groupe_unite1','groupe_unite2'}> name)

[#3]

Thanks for your answer,

but this expression don't use my alternate states, expression seems wrong just after your '$<'

[#4]

start from the beginning

groupe_1 and group_2 are dimensions right?

groupe_unite1 and groupe_unite2 are values? from which dimension?

[#5]

Thanks, I found my error, intersection are {[groupe_unite1]*[groupe_unite2]} and not in the two states are {[groupe_unite1]/[groupe_unite2]}.

With this it works fine.