Crosstab count problem
Posted: Wed Aug 25, 2010 3:31 am
Hello,
I have a problem with the crosstab component.
If I add a summary with count or countdistinct the grand total for a numeric value is the total sum not the distinct value and for a alphanumeric value the grand total is 0.
It looks like the grand total is calculated as a sum, maybe I'm missing a setting somewhere but I can't find any.
I'll attach a image and a sample report based on Simple cross tab
Regards Joakim
I have a problem with the crosstab component.
If I add a summary with count or countdistinct the grand total for a numeric value is the total sum not the distinct value and for a alphanumeric value the grand total is 0.
It looks like the grand total is calculated as a sum, maybe I'm missing a setting somewhere but I can't find any.
I'll attach a image and a sample report based on Simple cross tab
Regards Joakim