BILL OF MATERIALS (count quantity of Items)

[jozisvk11]

Hello, I have a problem with the bill of material. I need to count quantity of material, which is used in different level of bill of materials. I have the table:

ITEM                    ITEM/MATERIAL                     QUANTITY        

V0900                          V0901                                   1

                                   M0100                                   2

                                   M0101                                   2

V0901                          V0902                                   2

                                   M0100                                   3

                                   M0102                                   2

V0902                          V0903                                   1

                                   M0104                                   5

                                   M0105                                  10

V0903                          M0107                                  20

...

...

...

Now I need to find, how much material (Material is item starts with M****) I need to Item for example V0900.

Result should be:

ITEM                   MATERIAL                QUANTITY

V0900                      M0100                         5   

V0900                      M0101                         2

V0900                      M0102                         2

V0900                      M0104                        10 (V0902 is 2 times, so 2x5) 

V0900                      M0105                        20 (V0902 is 2 times, so 2x10)

V0900                      M0107                        40 (V0902 is 2 times, so 1x2x20)

Could you help me witm my problem ?

Thank you.

[Anil_Babu_Samineni]

Try to create straight table like below

Dimensions

ITEM

=If(WildMatch([ITEM/MATERIAL], 'M*'), [ITEM/MATERIAL])

Expression

=Sum(Aggr(Sum(QUANTITY), [ITEM/MATERIAL]))

[jozisvk11]

Dont work

[Anil_Babu_Samineni]

Okay