This report will show you the total values of stock assigned by cost centre and storage device for the previous month (or whichever date range you choose to filter on).

To build this report you will need to join three tables together: Assigned Items, Job Cost Centres and Stock Item ID.

To present the data, select a pivot table visualization.