Hello,
I'm using Crystal 11.0.0.1282 and I'm having trouble with Crosstabs.
I have 2 fields in the crosstab: count of occurrences and sum of dollar values of these occurrences. The report is grouped by date (monthly) and it's spread across 8 branches.
When I put the crosstab into GH1, it reports the numbers perfectly. The issue is with showing the percentage of each branch for each month. The reader would like to see the percentage of occurrences for the month as a percentage of the [highlight #FCE94F]total of the period[/highlight]. Eg. report is for the period Feb-Sep 2014.
Feb/2014
I'm using Crystal 11.0.0.1282 and I'm having trouble with Crosstabs.
I have 2 fields in the crosstab: count of occurrences and sum of dollar values of these occurrences. The report is grouped by date (monthly) and it's spread across 8 branches.
When I put the crosstab into GH1, it reports the numbers perfectly. The issue is with showing the percentage of each branch for each month. The reader would like to see the percentage of occurrences for the month as a percentage of the [highlight #FCE94F]total of the period[/highlight]. Eg. report is for the period Feb-Sep 2014.
Feb/2014
Branch1 Branch2 Branch3 Branch4
No Photos10 20 25 30
$100 $150 $200 $50
20 25 10 033% 44% 72% 100%
No Photos1$150 $100 $250 $0
Right now I can only show totals by month and I can't simply add another count and show it as a percentage of the total in the crosstab.
Any help would be appreciated!
Thank you in advance.
67% 56% 28% 0%
Total30 45 35 30
$250 $250 $450 $50
Right now I can only show totals by month and I can't simply add another count and show it as a percentage of the total in the crosstab.
Any help would be appreciated!
Thank you in advance.