I have been trying to achieve a Bill of Materials using various functions, and finally I was able to achieve (I think!) what I needed using the HierarchyBelongsTo function…
However, my costs are wrong as the higher level components include the costs for the lower level, so what I need to do is ignore the cost for any component that has a sub component. But how do I go about calculating which item belongs to which?
Thank you so much for your response, unfortunately I've tried the application but I would need it to show the sub component, as each product may have components that go in it...
Here was an example set of data I had previously uploaded:
