Topic: Cross Tab Grand TOtals 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.
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().
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
IP Logged
