This is my first time posting, and I apologize if this is the wrong place. I've only been filemakering for a few months, so again, apologies if this is a stupid problem.
I could use some advice.
I'm working on a solution that must create monthly reports in the following form:
I've given up trying to bend the summary fields to my will, and began using the following approach:
Make two new tables - Queries and Reports.
In queries table, I have fields for M1, M2, M3, Region, Category, Subcategory and four result fields (M1, M2, M3 and YTD.) I also have foreign key into the reports table.
Then in reports table, I portal into the Queries table.
When report is run, a bunch of queries in queries table are created. The Results are populated via ExecuteSQL expressions.
My question is mainly this:
Is this too backwards? I feel like maybe this is too weird of an approach and I"m just missing something simple about reporting and creating summaries?