10 Replies Latest reply on Dec 27, 2011 1:50 PM by JamesTorr

    Chart of Distribution of Products Sold

    JamesTorr

      Title

      Chart of Distribution of Products Sold

      Post

      Hey folks - I'm trying to make a button to navigate from the Company page in a version of the invoices database - to a chart (could be pie or bar) of the distribution of products sold to a particular company. 

      The attached graph seems to be only for one order rather than a sum of all the invoice line items for that company (grouped/organised by item). The graph is sorted by Product Name. I've actually made two of these - one with quantity ordered on the Y-axis and one with 

      Regarding table connections, I've got Customers --< Invoice Billing Customer --< Line Items

      Do I need to make a sum field here on the line items? How can I get this working?

      Thanks in advance!

      Screen_Shot_2011-12-22_at_15.11.27.png