6 Replies Latest reply on Jan 17, 2012 2:29 PM by JamesTorr

    Total Materials Used Chart needed

    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!