I have a BOM which look like this:

BOM:
Load * Inline [
Item_Parent, Item_Child, Amount
29M20, Z16, 1
29M20, Z17, 1
29M20, L00, 1
L00, R00, 2
R00, K10, 1
R00, K20, 1
R00, K30, 1
R00, K40, 1
20M20, L00, 1
];

My goal is to calculate the quantity needed for each item below the one I select.

E.g. if I select 29M20 then I want to know that I need 1xZ16, 1xZ17, 1xL00, 2xR00, 2xK10, 2xK20, 2xK30, 2xK40.

I have tried using hierarchy loads but I don't get the desired result, perhaps I am using it wrong.