We have a report that uses a crosstab (created by the wizard). There is one row group and three column groups, with totals at each level. The three column groups are region, location and gender. See the attached screenshot.
The user has asked if we can also add row total columns by location and gender, ie a total of the second and third grouping, to appear at the right before the grand total. So there would be a set of columns for totals by location and gender for all regions, along with subtotals by location (again for all regions).
Is this possible, and if so can anyone point me in the right direction as to how to do it?
The user has asked if we can also add row total columns by location and gender, ie a total of the second and third grouping, to appear at the right before the grand total. So there would be a set of columns for totals by location and gender for all regions, along with subtotals by location (again for all regions).
Is this possible, and if so can anyone point me in the right direction as to how to do it?
1 Answer, 1 is accepted
0
Accepted
Hadib Ahmabi
Top achievements
Rank 1
Rank 1
answered on 08 Jun 2012, 08:39 AM
It should be possible. Add a column group on top of the hierarchy (it has to be adjacent right to the Region group). Apply grouping by gender on it and you should get the totals.