get the # in common, and then the % in common between the two from the distinct customers

[Harleyquinxz]

Hi, I have a table like this -

And I want to find the count of common customers between a store pair, like this :

I'm looking to get the # in common, and then the % in common between the two from the distinct customers for the pair example for the %, store a has 5 customers, store b has 4, they have 1 in common, so 8 distinct customers for the pair, (1/8)*100 for % in common

[Rayshin · Accepted solution]

@Harleyquinxz 

hmm if i remember correctly, you need to reference copy the original table, make a relationship from customer id to customer id, put table1.store id as columns, table2.store id's as rows and use distinctcount(table2.customer id) as values.

[Harleyquinxz]

It's worked. Thanks so much.