I have a bill of material (bom). Lets call this BOM 301755.

BOM 301755 is made of these parts

```
    31161201 = need 1 pc of this
    29975413 = need 2 pcs of this
    299756 = need 2 pcs of this
    And 305958 = need 1 pc of this

```

This would be level zero.

Now Lets focus on one of the part. Part: 29975413.
Part 29975413 is made of:

```
PLTSSL902 = 1pc
CAPSSL902 = 1pc
PIPSSL4SCH40 = 3.96 
And LABSTR = 0.166

```

Now since we need 2 pcs of 29975413. 
how can I do the query so it will show as follows:

```
    PLTSSL902 = 1pc x 2 = 2 pc
    CAPSSL902 = 1pc x 2 = 2 pc
    PIPSSL4SCH40 = 3.96 x 2 = 7.92 
    And LABSTR = 0.166 x 2 = 0.332

```

I draw this for easier [![enter image description here](https://i.stack.imgur.com/lvUtq.jpg)](https://i.stack.imgur.com/lvUtq.jpg)to read. :)

thank you