Daily score/weekly average pivot table

Hello

I need a pivot table that does calculates the Weekly Average based on Daily Scores given the following information:

1. The Daily Score is based on a point system in .25 increments. If there are two scores for one day (I.E. 06/01/2011), the scores should NOT be averaged. Instead, if the Daily Score should be calculated by subtracting the number of point deductions from 100. (EXAMPLE: 06/01/2011 results are 99.5 and 99.25, so the final Daily Score for 06/01/2011 would become 98.75).

2. Once the final Daily Score is calculated correctly based on the point system, I need to group the final "Daily Score" by week number.

3. After the Daily Score is grouped by week number, I need to AVERAGE the final Daily Score for each date within that group for a weekly average.

4. This pivot table will be used calendar year and will have multiple Rep Names.

CROSS LINK:
http://www.mrexcel.com/forum/showthread.php?t=559722

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this.

Please add links to your cross posts.