How to heck if value exists in another table to create a pie chart?

[songzixian2016]

Hi all,

I have two tables:

Table X:

Name

A

B

C

Table Y:

Name

C

D

I would like to create a pie chart showing what value in Table X presents in Table Y: In above cases, C is present in Table Y while A,B are not. So the pie chart will look like below: we have 33% values in Table X present in Table Y.

How will I achive this either through manipulation in initial loading OR through calculated dimension or expressions in chart UI? (I prefer to do it in UI because the actual table is really large and I do not want to mess it up with each other during loading)

Many thanks,

Sherrie