I'm a senior accountant with a company that has a limited ERP system. Therefore, I have downloaded about 9,000 lines of data and I am now trying to summarize the account totals in an exclusive Layout that I can add budget totals and a field that calculates variance (operating expense analysis). I have written a script that controls a "Find" based on Start Month, End Month, Year, Entity and Location. I have attached a MS PowerPoint slide that details what I am trying to do.
To get a first go at showing a simple report, the Report Wizard (Layout mode -> Layouts -> New Layout/Report) might be useful, as well as the integrated FileMaker Help.