So to explain the issue im having, lets say we're having an lottery in my office based on sales.

So im importing a spreadsheet with the sales persons name, the date of the sale, and the sale amount.

Several sales happen every week, so there's several entries per person and week.

This person is the receive a lottery ticket for every 25000 he sells for each week, and it resets each week.

I want a report to show the number of lottery tickets he/she is qualified for per week.

So basically, a report where upon selecting the week number, youll see both the total sales figure, and each persons weekly sales number divided by 25000 and rounded down.

Thanks in advance