Skip to Content
0
Former Member
Nov 10, 2012 at 04:18 PM

Max, Min, and Average of Crosstab Data

125 Views

I've inserted a crosstab of data into my report which basically shows the date down the first column and the total count of test entries done each day in the second column. The Total summary field at the top of the crosstab sums all the daily totals up into one grand total for my entire date range. This is good. But I also need to find the Max, Min, and Average count values for the date range. How do I do that? How do I hook into the data the crosstab provides to display the Max, Min, and Average count values somewhere else in my report? I need to find the Max daily count, the Min daily count, and the Average daily count.

Thanks,

-Eric