Print Page | Close Window

Cross tab distinct count

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10653
Printed Date: 16 May 2024 at 2:02am


Topic: Cross tab distinct count
Posted By: yang
Subject: Cross tab distinct count
Date Posted: 27 Jul 2010 at 4:31am
Hi all,
I am trying to do a distinct count on the data on a cross tab, but the summarize field is wrong for the distinct count. the total value does not add up correctly.

 


Replies:
Posted By: kevlray
Date Posted: 27 Jul 2010 at 4:58am
I will try to explain what probably is going on.  I have a similiar issue when doing distinct counts and groups (the group totals do not match the grand total).
 
If whatever field you are doing a distinct count on has two (or more) records that meet the criteria for two (or more) groups, it will be counted once in each group, thus throwing the grand total off.
 
Example.  Distinct count of patient_Id, group by insurance carrier.  Patient has two insurance carriers.  It gets counted once for each carrier (twice counted), but counted once for the grand total.
 
I hope this helps.

Posted By: yang
Date Posted: 27 Jul 2010 at 4:52pm

hi, thank you for your reply. i understand the issue here. is there a way to customise the total?the individual count for the individual row are correct. i need to sum up the individual distinct count for the row. how can i do it? 

i am already using a view and i need to do distinct count.
 
 

Posted By: kevlray
Date Posted: 28 Jul 2010 at 11:25am
I know how to do it for groups, but not on a crosstab.


Print Page | Close Window