Print Page | Close Window

Cross Tab Grand TOtals

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17170
Printed Date: 20 May 2024 at 3:56am


Topic: Cross Tab Grand TOtals
Posted By: zrome
Subject: Cross Tab Grand TOtals
Date Posted: 31 Jul 2012 at 10:03am

I've been using crystal for a while but cannot seem to find a solution for this (am pretty sure its not doable but no harm in asking).

 
I want to show the column grand totals as the SUM of the numbers in the crosstabl; however, want to show the row grand totals as the AVERAGE of the numbers. Any dice? Thanks.


Replies:
Posted By: Sastry
Date Posted: 01 Aug 2012 at 8:47am
Hi
 

 

Yes you are right.  It is not possible because, in cross tab once you insert any field on Rows or Columns it create groups and groups will always shows aggregated values.

 

In crystal you can't use two aggregate functions at a time.   The row / column totals should either sum() or Average().

 

 
   


-------------
Thanks,
Sastry

Posted By: zrome
Date Posted: 03 Aug 2012 at 9:44am
Well, for my purpose, the weighted average seemed to fix this issue.


Print Page | Close Window