How to make a weekly average 1

[Saj0916]

Hello,
I am new here and was wondering if anybody could help me out here. I have an account id, date, transaction id, transaction amount(and total amount). I was wondering how I could sort and make a field definition for the amount spent each week and month by an individual person. Thanks for the help.

 

[Montanac50]

Make a calculationfield where you concatenate weeknumber and year.
A second one with year & month.

This will give you the start to find all the records for a given week or month.

Next you can do your calc on the found set of records.