Chart Summary: Minimums, Maximums, Totals, Averages

[JHeimall]

I currently have a report with 4 layers of groups. There is a chart in each Group Header depciting the Sums of the Group right below it. So if there is a grouping for year 2005, the chart in that group shows the sums of the data for each of the 12 months. I would like to show summary points of the data which include the maximum month and the minimum month. I was able to grab totals and averages for the chart.

Average - Sum ({tbl_eEventSummary.eEventTotal},{tbl_eEventSummary.eEventYear})/DistinctCount ({tbl_eEventSummary.eEventMonth},{tbl_eEventSummary.eEventYear})
Total - Sum ({tbl_eEventSummary.eEventTotal},{tbl_eEventSummary.eEventYear})

However, the minimums and maximums are causing some trouble since they would be minimums and maximums of summary values which Crystal does not appear to play nice with.

Please let me know if this is not clear enough.

Thanks.