AnsweredAssumed Answered

Summary by Week, Month and Year to Date on same line

Question asked by jfackler on Feb 22, 2016
Latest reply on Feb 23, 2016 by beverly

Hi all,

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:


Fiscal Week#

Region #

District #

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.