I have a cross tab that has a priority level as the rows, a department as the columns, and a distinct count of an indicator ID number is the summary. This works fine and returns the correct data.
However, when the grand totals are displayed, crystal seems to be mis-calculating them. I think this is because a few of the indicator numbers are present in more than one department, and the total is performing a distinct count as well, which it shouldnt be.
Surely the grand total sections should just add up the numbers displayed in the cross tab, but they seem to be doing their own distinct count calculation on the data.
Is there any way to force the cross tab totals to simply add up the values displayed in the cross tab rather than second guessing the data?
Thanks