I've got a number of revisions of an item with its constituent parts. I'd like to get a % similarity of each revision to the active revision. I'm assuming Advanced Analytics Toolbox will be used here to generate some sort of Correlation Coefficient. Here are two sample Revisions.
Bill of Material | Revision | Component | Weight | Active |
GuitarStarterPack | 0001 | Fender | 7.5 | N |
GuitarStarterPack | 0001 | Amp | 15 | N |
GuitarStarterPack | 0001 | Pick | .001 | N |
Bill of Material | Revision | Component | Weight | Active |
GuitarStarterPack | 0002 | Dean | 7.2 | Y |
GuitarStarterPack | 0002 | Amp | 15 | Y |
GuitarStarterPack | 0002 | Pick | .001 | Y |
GuitarStarterPack | 0002 | Songbook | .3 | Y |