AnsweredAssumed Answered

Chart of Distribution of Products Sold

Question asked by JamesTorr on Dec 22, 2011
Latest reply on Dec 27, 2011 by 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

Outcomes