Bill of Material Totals

[hk2018086]

I have a table in this format and need to find totals usage of all parts. please help.

Level Part Qty

1A1

2B5

3C3

4D2

2E1

3F1

 Please note that is related to the hierarchical totaling For example the total qty required for Part C, which is at Level 3 and falls under Level 2 of Part B and level 1 of Part A, would be Part B qty X Part A Qty. 

For Part D the total will = Part D (2)  x Part C (3) X Part B (5) x Part A (1) = 30

Lower levels are parents of higher levels

In the example below Bearing Ball = Bearing Ball (10) x BB Bearing Ball (10) x HL Bottom Bracket (1) x Mountain 100 Black 38 (1) = 100

Another example is shown below.