Determine level within multi level parent child hierarchy

Hi all! I have a table that shows me a multi level parent child hierarchy: Parent Child Quantity 1 A1 1 1 XC2 2 A1 B2 5 B2 XC7 8   As o...