Finding overlap in data - differentiating customers and products

[hardleers]

Hello everyone!

Some help with figuring out this question. I'm stuck and looking for solutions. I have a certain group of product id's and these are bought buy various customer id's. Now I'm looking for overlapping percentages. I can figure out how many of the total customer's bought a certain product. For example product A has been bought by 60% of the total customers. Now lets says that product B also has been bought by 40% of the customers. I want to know how many overlap there is between those percentages. Maybe they are all the same and product A has 20% more distinct customers, maybe there is no overlap and they are totally different. Is there a nice way to straight up show this?

Thanks!

[jwjackso · Accepted solution]

Look at the P()  function.

Using the P() function in Set Analysis   customer=P({<product={'A'}>}customer)*P({<product={'B'}>}customer) would be the intersection of the customers that used products A and B.