You can preserve the indented structure of an Enterprise PDM computed bill of materials (BOM) or a saved BOM when you export it to a Microsoft Excel spreadsheet. When prompted, choose to add a Level column to the output file. The added column contains a numerical representation of the BOM’s levels.
To preserve the indented structure of a BOM:
- In Windows Explorer, select a vault assembly.
- On the Bill of Materials tab, click BOM Display - Indented .
- Click Open As CSV .
- When prompted to create a Level column in the CSV file, click Yes.
A Level column, with numerical values representing the BOM structure, appears as the first column in the spreadsheet. You can use the column to sort the exported BOM.