Show two month data in FileMaker's Starter solutions Invoice Dashboard
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?
PS. Sorry for the Geek wording on the image header. It reads "Invoice TESTING August / September 2014".