I have a Table that depicts all customers and the products they have purchased. There are about 250 Products and about 500 Customers for total of about 2800 Product Client combination. I am attempting to figure out the various types of combinations of products that are frequently purchased.
Additionally, I have some standard combinations of products that I have grouped together and would like to see what accounts have that grouping of products.
How would I accomplish this ?
Any assistance is appreciated.
_____________________________________________________________________________________________
Thank You for the guidance. I have enclosed a sample file and I would like to interrogate the data to see :
a) What are the frequently purchased combinations of products in order of reducing frequency : Who are the clients buying each combination ?
b) How many and which clients are buying Combo 1 or Como 2 or Combo 3 etc. in the master list ?
Bookmarks