Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Averages to Cross Tab

Status
Not open for further replies.

CJP12711

MIS
Jul 23, 2001
116
US
I have a table with the below fields:

ID Date
1 3/29/08
2 3/25/08
3 3/15/08
4 3/14/08

I have a cross tab report with a Saturday label as the row, the date (by month)as the column, and a distinct count on the ID number. This all works beautifully. The part I am having trouble with, is adding an average to the summarized field. If there is a total of 4 Saturdays in a month, and January had 16 cases, I want to show the average number of cases per Saturday - in this case, 4. Does anyone have some hints for doing this?

I'm using Crystal Reports 10.

Thanks!
CJ
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top