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 |
