Cross table to identify cross selling of products

[kh99523]

Hi community,

in the attached file, I have two tables:

1. Dataset: Vertical Axis: Customer 1-30; Horizontal Axis: Product 1-8

2. Analysis: Vertical and Horizontal Axis Product 1-8

In the analysis, I want to know how many times (%) products were sold together - e.g, how often is Product 1 sold together with Product 2?

Do you have an idea how to solve this with a formula that can be used for the whole table?

Thanks in advance!

[WideBoyDixon]

D5 formula:

Please Login or Register  to view this content.

Copy the formula to D5:K12. Format those cells as percentage.

WBD

[kh99523]

not all heroes wear capes