Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Adding an average as the grandtotal in a Crosstab Post Reply Post New Topic
Author Message
AnthonyJ
Newbie
Newbie
Avatar

Joined: 20 Nov 2007
Location: United States
Online Status: Offline
Posts: 37
Quote AnthonyJ Replybullet Topic: Adding an average as the grandtotal in a Crosstab
    Posted: 20 Jun 2008 at 3:12pm
Hi,

I created a CRXIr2 crosstab report.

In the customize style tab of the crosstab export, there is a Grandtotal option for the rows and columns. Instead of summing up my metric, I would like to get the average to be displayed in the Grandtotal column.

Any tip ?



IE. The resulting crosstab,

Type  Jan   Feb   Mar   Total
----+-----+-----+-----+-----
A      10    20    30    60 -> 10+20+30
B      40    50    60   150 -> 40+50+60


The desired result (the total should be average of the 3 months),

Type  Jan   Feb   Mar   Total
----+-----+-----+-----+-----
A      10    20    30    20  ->  60/3 = 20
B      40    50    60    50  -> 150/3 = 50
XIR2 on Unix Solaris
CRXIR2, Oracle 9i/10g
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.