AnsweredAssumed Answered

How to display Monthly Invoice Totals on Dashboard

Question asked by PauletteDalPorto on Feb 6, 2013
Latest reply on Feb 7, 2013 by PauletteDalPorto

Title

How to display Monthly Invoice Totals on Dashboard

Post

      

     With the help of the Invoice Starter Solution, I have made a database to do some financial tracking.  I have created a startup screen layout (like a dashboard) and everything but one thing on it works.  I would like to show the monthly expenditures (invoice totals) in a graph by Fiscal Year.

      

     The startup screen is based on the invoice table.  the chart doesn’t work and only shows one total and it’s the grand total of all invoices. 

     Any suggestions on how to get this to work?  I have moderate experience with Filemaker and in database design in general.

      

dashboard.JPG

Outcomes