In FileMaker, you can achieve this with subsummary parts in a list view layout where you've removed the body part. You'll need a field with a calculation such as: DateField - DayofWeek(dateField) + 1 so that all records from the same week have the same value in this field. Then you'd add a sub summary part to your layout with this calculation field specified as the "when sorted by field". Add your fields to this layout part, (A summary field that computes the total of your Net P&L field can produce the weekly sub total), click th body part label and press delete to remove it. Las step is to find your records and sort them by this same field that you specified in the "sorted by" option for the sub summary part.
OK - I went to Layouts. I created a new List Layout.
I created a field called "Calculated Month" whose formula is:
Timestamp - MonthName ( Timestamp ) +1 (where "Timestamp" is the auto-entered timestamp of a new record created)
(see attached screenshot)
I removed the Body part (all the fields were originally in the Body part when I created the layout, so as you can see, I added the Summary part and just dragged the fields out of Body down ... and removed Body).
Now, when I go to Browse - I have no fields to use for search/find, or browing - I assume, because there is no body? What am I missing?
First, your calculation mixes TimeStamp numbers with text (monthname) so it won't produce the expected value here. My example is set to work with a date field, not a timestamp.
If you want a common date for all records from the same month and have this date entered as part of a timestamp. use this:
Let ( D = Getasdate ( TimeStamp ) ; D - Day ( D ) + 1 )
Use this calculation field as your "when sorted by" field in the sub summary part.
In order to find records for this report, you'll need to either use a script, use a different layout where the fields are available in the body, or both. After finding the records you want, you can sort them and switch to this layout.
Note that if you don't sort the records in an order that uses the "sorted by" field, you will not see much of anything in this report.