0 Replies Latest reply on Apr 28, 2015 10:41 AM by GrahamKeogh

    Charts per Client showing Invoices per month

    GrahamKeogh

      Title

      Charts per Client showing Invoices per month

      Post

      Hi all

      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!