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
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
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