Alternative states with intersection and unon

[Anonymous]

Two Month filters with alternate states set1,set2

selection:

set1-June2017

set2-May2017

Count({set1*set2} ID) is not giving me intersection

count({set2-set1}D) is not giving me CIN's only present in SET2

individual sets are giving me correct counts. Not sure where it is going wrong?

[Anil_Babu_Samineni]

How is your full expression looks like?

[Kushal_Chawda]

see this

Intersection in Alternate States

[Anonymous]

It is nothing that complex I am using.

Two period filters with alternative states and want to find Intersection and left only, right only Records.

It works fine for

set1 : Count({set1}ID)

set2: Count({set2}ID)

Not working for either of below:

Intersection is not working for

Count({set1*set2}ID)

Left only

Count({set1-set2}ID)