HAS ANYBODY HAD ANY LUCK CREATING A BOM THAT HAS COLUMNS THAT ONLY SHOW PART DESCRIPTIONS/PART NUMBER BASED ON THE CONFIGURATIONS IN AN ASSEMBLY.
SPECIFICALLY WE HAVE AN ASSEMBLY THAT HAS SAY THREE CONFIGURATIONS. WE WANT THE BOM TO SHOW PARTS COMMON TO ALL CONFIGS ACROSS THREE COLUMNS, BUT WHERE THE PART IS NOT IN A CONFIGURATION IT IS NOT SHOWN IN THAT CONFIGURATIONS COLUMN.
EXAMPLE: ITEM P/N DESC1 DESC2 DESC3
1 10 BLAH BLAH BLAH 2 20 BLEK BLEK 3 30 FOO 4 40 BAR