sort bar chart based on total value

[ddma]

Hi.

I would like to create stacked bar chart in Cognos 11 Active report and sort it but looks like Im missing something.

I have dataset that consists of 3 columns:
1. Class
2. Boy / Girl
3. Name Surname

Based on it I want to create stacked bar chart, that should show:
on X: total number of persons
on Y: Class

additionaly: Class should be splitted by Boy/Girl AND sorted by total number of persons

Example:

ClassA -----=======

ClassC --=======

ClassB ----
          0     10    20

where - is boys and colored in red
where = is girls and colored in green

I am able to create such chart, but when I sort, it sorts in very weird way (probably by boys value, but not by total boys+girls value).

Below what I do:
1. Chreate stacked bar chart
2.Properties:
Default Measure X-axis: Name Surname
Series (Primary Axis): Boy/Girl
Categories (Y-Axis): Class

Then I go to Query and choose Name Surname - Detail Agregation: Count. Then choose Sort Name Surname ascending. Then go to Series (Primary Axis) Palette and change colors I would like to have.

Could you pls advise what Im doing wrong? Am I missing something? Thanks

[dougp]

Try adding a data item to the query...

Code Select Expand

total([Name Surname] for Class)
...and using it to sort.