Charts per Client showing Invoices per month
I am trying to achieve something that is on the Dashboard layout that comes with the starter solution for Invoices within fmp13. I want to be able to have a graph that shows the invoice amounts per month per client, so as you scroll through each client, it would display each ones different sent of data.
I currently have a portal that shows invoices raised under that client. But for reporting I feel a chart would be very handy. The problem I am finding is that the invoices are part of my Quotations table and are defined by a 'Type' field. I have tried to use the starter solution code but I am stumped, and don't know how to relate or link between the two in relation to the chart.
Also wondering what is the best way to show a total on the same page that shows a summary of the invoice amounts per client (like the starter solution).
Any help would be great!