bar chart order

[mcaizpp2]

Hello I cant get this right so im going to try to breakdown what im doing and see if anyone has any suggestions.

I am trying to create a bar chart.
This bar chart will have 4 bard (A - D).
Each Bar(e.g. Band A) will be futher divided into 6 segments (1-6).

so one bar would be
Band A - 30%(1); 0%(2); 30%(3); 10%(4); 10%(5); 10%(6)

the data expert looks like -

on change of -

(1) view.Band
(2) view.PCTotal

Show value(s) -

Count of @PCScoreTotal

@PCScoreTotal formula is -

count({VIEW_RPT_ScoreByBand.PCTotal},{VIEW_RPT_ScoreByBand.PCTotal})

I also created a group (which i suppressed) on PCTotal.

My problem - The bars are produced in the correct
order A-D but the segment(1-6) dont. The order of segments is e.g. 1, 2, 3, 5, 4, 6.

I need to find a way of specifiy te order in which the segments are displayed in each band.

I have tried to do a specify order on the PCTotal field but nothing.

Please any suggestions welcome. I've spent a long time on this problem and still cant find an answer.

Thanks for any help.

 

[lbass]

I responded to your other post. Please provide feeback there.

-LB