item type unit(l) 1Dec16 2Dec16
Coffee Capuccino 0.2 5
Coffee Cafe Latte 0.4 5
Coffee Tea 0.2 5
Other Cake 2



I want a Pivot table to create dynamically when i add new date as below
multiple the quantity with unit when present and sum by item (0.2*5+0.4*5+0.2*5=3 for Coffee)

item sumof1Dec16 sumof2Dec16
Coffee 3
Other 2

Can someone please help me to create Pivot?