How to modify the summary of a crosstab to produce the desired result?

[mgibson]

Hi,
Can someone please help me with a problem we've encountered when trying to get percentage summaries to operate as desired on a crosstab report in Report Studio?
Currently, our report displays like this (using the default summarisation function);

             Female   Male     Female   Male 
FACULTY A             CAMPUS A   66   33   67%   33%
       CAMPUS B   86   74   54%   46%
      CAMPUS C   17   19   47%   53%
       CAMPUS D   16   13   55%   45%
Summary             185   139   47%   33%

We woud like it to display like this:
             Female   Male     Female   Male 
FACULTY A             CAMPUS A   66   33   67%   33%
       CAMPUS B   86   74   54%   46%
      CAMPUS C   17   19   47%   53%
       CAMPUS D   16   13   55%   45%
Summary             185   139   57%   43%

The second table shows how we'd like the percentage summaries to work, ie. that they are a percentage of the Male / Female Summaries before it.

Note that changing the solve order has been tried, and doesn't work.

Note that I've raised this case with Cognos support, and they've indictaed that it can't be doen, and has been lodged as an ER - which surprised me greatly, so I'm hoping the user community is smarter then Cognos support and can help me with this.

Regards
Mick

[almeids]

Mick-
   I'm as surprised as you are - seems you ought to be able to do what you're trying.  Are you running Reportnet or Cognos 8?  I'm not familiar with the term "solve order" (which certainly sounds like what you're looking for) so I'm thinking C8.
   Worst case you can pull the summary records separately and union them with your campus details, though you'll need to add a dummy data item to both queries so the summaries sort last, and perhaps some conditional formatting to the crosstab to make them look like subtotals.
Steve

[almeids]

Mick-
   Disregard the version question - you've probably realized that I copied my response to your question in another forum where it wasn't clear which version you were running.
Steve