Hi, I have a problem with showing totals of percentage values in my Crosstab. Take the example below:
I have X number of columns showing months and finally a Total column in the end. Each column contains one row showing Number of A, one row showing Number of B and one row showing Number of A/Number of B as a percentage.
This works fine for all columns except for the Total column. Crystal doesn't seem to understand that I want to divide the Total A with Total B, but just makes a total for the percentage as well.
An example:
Let's say that I have three identical columns showing:
Number of A = 1
Number of B = 10
A/B = 10%
The Total column then shows:
Total Number of A = 3
Total Number of B = 30
A/B = 30% (should be 10%!!!)
Any idea how (and if) this can be done in Crystal Reports?
IP Logged
