Correlation between values in table

[ChristianE]

Hi

I have a table with articles from different producents which fit on different cars

Example:

Part     Producer    Car

1           a                1

1           a                2

1           a                3

3           b                2

3           b                3

3           b                4

(IE Part 1 from Producent a fits on car 1-2-3, and Part 3 from Producent b fits on car 2-3-4)
Im trying to create a measure which shows the correlation between the Articles on cars in my table, and show the ones with the highest fit

For example the above would show 

Part     Producer    Fit

1           1               (3,b 2/3)

[Nathaniel_C]

Hi @ChristianE ,
Not sure if I understand your expected result.  How does a producer get a 1, when the only values are alpha. Is this a count? Also please explain (3,b 2/3).
Thank you,

Nathaniel

[ChristianE]

Sorry after i wrote the example out i changed producers from numbers to letters try to make it more understandable, but it appears i missed the one in the result. It should be:

Part     Producer    Fit

1           a               (3,b 2/3)

Meaning part 1, from producer a, is like part 3 from producer b, in 2 out of 3 cases (where the three is the number of possible fits for part 1). Does that make sense?