This is the first time I am really working with charts but I cannot seem to get the chart to show the results I want.

Pull from one table.

Getting value in inv_total if the record has the logical field invoice set to true.

Simple and does that but no mater what I try I cannot get it to summarize the inv_total by the customer.

So if the customer has more than one invoice it shows a separate bar on the charge for each invoice instead of the total invoice values for each customer.

In a calculated field this works
but in the chart it will not accept things like that.