I would like to create a simple report in Crystal. Just an annual report, somethign like this:
Jan Feb Mar Apr
ABC 1 3 5 2
XYZ 1 3 5 2
Avg 1 3 5 2
I have a problem creating the last "Total Avg". Each of the monthly data points are already averages. They are, already, grand totals. So I can't do one big average at the end. (Basically, i'm taking avg out of avg in total which i don't want it)
Is there another way to do take care of this in Crystal?
Can someone please point me in the right direction? Thanks.