Hi all,

Can someone please help me . I have a product which is a value pack that has a unique material ID i.e 9311783036140, ZZZExcel 2 Value Pack## and sales figure of 165. This value pack is comprised of 2 other products i.e 2 of 9311783074852, Excel 2 63mm & 1 of 9311783074838, Excel 2 75mm.

What i want to do is create a report where it breaks down the Value Pack sales figure, where it will times the components by 2 and 1.

Therefore my final result should look like:
Material ID Product Descrip Sales
9311783074852 Excel 2 63mm 110
9311783074838 Excel 2 75mm 55

Thank you for your help