In V5 Catia I could easily get a list of parts with quantities showing how many of each component or sub-component are contained in the product. V5 / Assembly Design | Analyze | generate Bill-of-Material would do this and let me export to an Excel spreadsheet. 

What do I need to do in 3DX to do the same thing? I've played with the Spreadsheet in Product Modification, but it puts every instance on a single row instead of grouping them by part number and specifying a quantity. Is there something I'm missing here? How to generate a BOM in 3Dx that is exportable to Excel?