Creating Specific Pivot Table format

Hi,
I have a database collecting all my production data from a factory, and I would like to produce a pivot table that mimics my production report - to make things more efficient
I've tried many approaches but I am no expert in Pivots, therefore got stuck.
The sheet with the Data and Desired outcome is attached, any help would be hugely appreciated !!

Note: I am filling the data in a way where my production is recorded on 1 line and then all my consumables are on the lines below, with the some data repeated for pivot to pick up. You might find this incorrect and I could change the data capturing method based on any suggestions here.
Thanks in advance
Luka

I can't seem to be able to post attachments or links - hence not sure how to get the file across...any help?

Okay so i solved this using Pivot Table DAX Functionality
This forum won't allow me to paste links unfortunately; however go to youtube and type DAX - handful of resources
Good luck !!