Need week-to-date totals for each week in a month

[dtrinite1]

I need to show totals in a report for each week in a month

Result Example:

week ending 12/7/02 142 $213,678
week ending 12/14/02 154 $345,340
etc.
etc.

Is there a way to use the LastFullWeek function to do this and not go into a previous month ..?

Thanks in advance for any feedback

 

[JacobsAunt]

I suggest that you group your data by calendar month. Suppress that group, then group by week. After you do this, you can use the various summary functions to produce the desired totals.