How to display Monthly Invoice Totals on Dashboard
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.