3 Replies Latest reply on Sep 11, 2014 7:19 AM by philmodjunk

    Show two month data in FileMaker's Starter solutions Invoice Dashboard

    AristotelisOikonomou

      Title

      Show two month data in FileMaker's Starter solutions Invoice Dashboard

      Post

      Hello everybody,

      I am building a solution for a customer based on the Invoices db of the Starter Solutions. The customer pays his providers every two months, so he wants to see two months data in Dashboard. I have managed to show two month data in the Invoices portal but I cannot figure out how to make the Total of these invoices to conform. It is the  global calculation field inside "Customers Dashboard"  table named "Total All SQL". 

      Can somebody help, please?

      Thank you.

       

      PS. Sorry for the Geek wording on the image header. It reads "Invoice TESTING August / September 2014".

      Two_month_data_in_Dashboard.png