two subsets - i need the intersection

[#1]

Hi at all,

i have following question:

I have two Dimension with results:

Example:

DimensionA	DimensionB
A	L
B	K
C	R
D	A
E	X
F	C
G	A

I need a Count of the Intersection between Dimension A and Dimension B:

For this Example it is A - A, C - C and A - A. I need to count the distinct pairs. In this example the Distinct Count = 2 becaus A - A and C - C.

Which formula is correct?

I tried something like this without success:

"COUNT( ({<DimensionA>*<DimensionB>}) DISTINCT DimensionA)

Thank You!!!!

[CELAMBARASAN]

Both the fields are in same table?

[#3]

yes

[mdmukramali]

Dear kstyles089,

Try the below two expressions

1)

=count({<DimensionA={"=count({< DimensionB=P(DimensionA)>}distinct DimensionA)>0"} > }distinct DimensionB)

2)

=count({<DimensionB={"=count({< DimensionA=P(DimensionB)>}distinct DimensionB)>0"} > }distinct DimensionA)

kindly find the attachment.

I hope it will help you.

Thanks,

Mukram.

[#5]

Dear Mukram,

thanks a lot!

But sry... My mistake. The two dimension are not in one table.

The Tableview looks like following example:

so your expression doesn`t work. Do you have a solution for this problem?

thanks, kstyles089

[mdmukramali]

Dear kstyles089,

can you attach the sample file.

Thanks,

Mukram

[CELAMBARASAN]

Hi,

I hope the attachment helps