Chart of Distribution of Products Sold
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!