I'm started working with FileMaker Pro 15 four months ago and I'm struggling with finding a way to aggregate and cache calculation results so that my subsummary reports and charts will execute faster.
I read both the FM Basic and Advanced manuals, read through the bulk of the FM 14 Missing Manual text, and I still stuck. Honestly, must have missed a concept for the above.
I have 500K rows of sales data consisting of the following fields: primary key (UUID), location code, product ID, sale date (month & year), Dollar sales, and unit sales.
I'm trying to report on sales by location and also as a rolled up number by month, year, quarter, etc.
Does anyone have an example or know where I can find a paper on how to aggregate the data and store it some place to help speed up the rendering process?
Ideally, I'd like to script a way to update the data when I need it refresh the data.
I'm running the app on a Mac, but have hopes of moving it to FM Server in the future.
Thanks in advance,