I think I understand what you are asking for now. What you are asking for could be a problem especially when dealing with Assemblies and Subassemblies.
For example, here are 2 switches. The each are comprised of three parts two of which are comon to each switch. The Switch TAGS are SS01 and PB01. This is an excerpt from my BOM using "Display in BY TAG format" (This list is sorted BY TAG):
[pre]
PB01 1 C21ED01 BACO PUSH BUTTON - TWIST RELEASE MUSHROOM
22.5mm
RED 28mm MUSH, ROUND PLASTIC
1NC
SCREW TERMINALS
MARTEC
1 23E10 BACO 1NO CONTACT BLOCK, SCREW TERMINAL
22.5mm
1NC
SCREW TERMINALS
MARTEC
1 233E BACO CONTACT BLOCK ASSEMBLY MOUNTING CLIP
22.5mm
MARTEC
SS01 1 C21KT03 BACO SELECTOR SW - 2 POS MAINT, NEMA 4/4X/13
22.5mm
BLACK LEVER
MARTEC
1 23E10 BACO 1NO CONTACT BLOCK, SCREW TERMINAL
22.5mm
1NO
SCREW TERMINALS
MARTEC
1 233E BACO CONTACT BLOCK ASSEMBLY MOUNTING CLIP
22.5mm
MARTEC
[/pre]
These two items are seperated by about 15 other items. I can readily see what components I will need for each assembly but I cannot tell how many of each component I will need. To do that, I would have to generate another BOM using "Display in Tallied Purchase List format." That way, I now only purchase the items I need.
It seems to me that the "Display in BY TAG Format" is what you want. Am I understanding your problem correctly? It would be very helpful (as Nate suggested) if you could supply us with an example of what format you are trying to accomplish.
Willing to help,
Robert Hanrahan
Weigh Right Automatic Scale Co.
ACE user since 1997
Bob Hanrahan
Ace User since 1998
If this answered your question, please click on "Accept Solution"