First off, I’m sorry to see that this wasn’t addressed sooner. :frowning:
What I suggest is using a new view to display the data you’re seeking, instead of building a summary table. The latter could be done, but building a view in the same table would be much easier.
First you’ll need to add a new formula field to your table that will calculate the week number based on the {Date} field. Name it {Week Number}, and use the formula: WEEKNUM(Date) . Feel free to hide this field once it’s made. (Note: if you need to change the day that each calculated week begins, add that as a second argument; i.e. WEEKNUM(Date, "Monday") )
Next create a new view for your table, naming it something like “Summary” or whatever you prefer. In that view, add a new group that’s driven by the {Week Number} field. This will make groups by week number, and each group will have its own summary of the values in the {Amount} field in the summary bar at the top of the group.
