AnsweredAssumed Answered

Total Materials Used Chart needed

Question asked by JamesTorr on Jan 17, 2012
Latest reply on Jan 17, 2012 by JamesTorr

Title

Total Materials Used Chart needed

Post

Hey chaps - I've adapted the Invoice Template DB to my own needs a little - and would like to pull some charting info out of it. 

I have a plastic manufacturing company - and would like to know the amount of materials I use - totted up in graph form. 

I have the line items table with products on it. Each product is made from a certain material and weighs a certain amount. I've got a materials table with information about them on it, but really I'd just like to know the total amount of materials used across a search - possibly with a button linking from the Invoices table. 

Any ideas what sort of summarising/sorting I'll need to do here? I've made a 'product weight sum' on the line items table for the X axis on a bar graph and the material type on the Y axis, but I think this just ends up totalling the whole lot of products rather than breaking it down into different materials.

Thanks in advance!

Outcomes