Possible with Macro
It depends on what your expected output to be. Ignoring the breakdown by column, this is basically an indented BOM, which is a setting available on the BOM within the drawing or assembly.
I've had partial success using BOM equation columns (w/o macros), see attached.
It's a numbered indented BOM structure and since subparts aren't numbered, the column equation checks for blank & non-blank "ITEM No" values and returns either the regular "PART No" or an empty string.
I used this same logic for the QTY column.
I inserted a new top BOM row to add the main assy and this row was automatically numbered ITEM No 1.
I tried using this item # "1" to conditionally display (using an equation column) the main assy configuration name for line one only, but I had no success.
I tried "$PRP:SW-Configuration Name" (& $PRPSHEET in case I had it backwards) in the equation and I also tried to create a custom property from this, but no luck.
Perhaps, someone else out there can carry this ball over the goal line.
I've attached the drawings PDF and a pack and go with all of the files.
Note: All but one of the parts and assy files are empty. There just for BOM manipulation.
Perhaps this will bring you closer to your goals.
It seems this will only work for 1 level of subassemblies, is that correct? I wish SW had a built-in solution for this type of BOM.
As far as I know, SW's BOM is just one indent deep.
Perhaps a macro would expand BOMs.
SW probably sticks with one level. If they go two, someone will want three...and so on.
For those looking for more BOM levels (maybe as a variable set in doc properties), all I can suggest is to submit the request to SW.
Perhaps it will gather enough momentum and get implemented.
Hello Kevin Chandler,
Thanks for reply. Your text will be useful to me :-)
Naveen Kumar Gongu.