How to make a weekly summary report for many weeks
Okay: I'm new to FileMaker and am using FM11 on a MacPro. I have a database populated from an Excel spreadsheet.
One table of that spreadsheet consists of two columns: a date, which is unique, and a weight.
I need to produce a report for ever Wednesday that computes the average weekly weight which begins on Tuesday, the day before, back to the previous Wednesday. It also needs to display the current weight on the Wednesday.
I can't seem to figure out how to do this.
I can do it for a single week, or the current day, but I cannot do it for the entire database which consists of about 1,400 records.
Just to be clear what I'm looking for is a report for every Wednesday in the database, where the previous 7 days have the average weekly weight computed and display. Nothing else.