I am trying to get averages and numbers by weeks

[BobMcConnell]

Date avg num avg

4/14/2004 35 35 70
4/15/2004 33 87 65
4/16/2004 34 72 60
4/17/2004 32 67 22
4/18/2004 30 22 34

WEEKLY AVERAGE 4/14-4/18

next week

TOTAL AVERAGES

I can seem to average the last column since the first column is already an average and I have grouped the dates. After that I'm stuck.

 

[synapsevampire]

Create another grouping outside the daily for weekly.

Now you can handle each week the same way.

As for totals, right click whatever field it is that you're originally averaging (not the average that you're displaying) and select Insert->Summary->Average.

This is Crystal version dependent, as well as what the data looks like.

-k