Help Organizing data for use in a Pivot Table

Hello,

I am trying to organize data from a Bill of Materials that I could then use in a pivot table. In the file uploaded I have the parts broken down to show what assembly they flow into with everything eventually flowing into the Top Level Assembly 184400. For example, parts 184412, 184414, and 184415 are assembled in Station 1. Those 3 parts make up the 184403 subassembly. In Station 2 subassemblies 184403, 184404, and 184417 are assembled to make the 184402 assembly. In Station 3 184402 and 184401 are assembled to make up the complete Top Level Assembly 184400.

What I want to be able to do with the Pivot table is to be able to see what parts or sub assemblies flow into an assembly and where those parts are stored. For example 184400 would show it's made up of parts 184402 and 184401 and that they are stored in Station 3. I also want to be able to see how many parts make up those parts and where they are stored until I can get all the way down to the piece part level.

test file snip.PNG