I have a crosstab report that shows individual preferences based on age range and relationship status. Currently the value fields show a count of the number of persons. I would like to insert 2 additional columns to display the total number of males and females respectively. The columns are to be inserted to the left of the total column.
This is the original report.
So the report should look like this, displaying the total number of males and females for each relationship status for each age range. Then the grand total for both gender.
By the way I am new to crystal reports. I am using 2011
I cannot modify the datasource, sql server db, it is not allowed.
Please let me know if you require additional information and I will provide it. Any help will be much appreciated, I have been at this for sometime now 😔