Grouping; adding totals by subgroup, is this possible?

2 posts, 1 answers
  1. Derek
    Derek avatar
    118 posts
    Member since:
    Oct 2008

    Posted 06 Jun 2012 Link to this post

    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?

  2. Answer
    Hadib Ahmabi
    Hadib Ahmabi avatar
    181 posts
    Member since:
    Nov 2011

    Posted 08 Jun 2012 Link to this post

    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. 
Back to Top