Looking for a way to put a summary of numbers (count of transactions) into a report and have it summarized in a single horizontal line - by week; by month; by Year to Date;
The data is in the file on a daily basis;
Want to report on this by store;
Therefore ideally the report would look like this going down by part and summary and across by summary at the store level for different lengths of time:
Store # - Store Name - Fiscal Week Transaction Count -- Current Fiscal Month Transaction Count -- Current Fiscal Year To Date Transaction Count.
Is is possible to get all of these in one line; all in one subsummary part of a report?
I know I can create different layouts with different parts or sorted differently to get the individual summary counts - but having 100 different stores, I'm trying to save space and trees by putting them all together. I know how to do this in Excel; but not so easy in FileMaker so far.
Thank you anyone for your suggestions.