sort in stacked bar

[manoranjan_d]

hi all,

how to sort the stacked bar as per the value

below is the data

dept           student

IT                100

CSE             200

Robotics          300

CSE               500

Robotics          50

robotics          150

now when i used dimension as Dept and calcualted dimension as 1 and student count as expression i m getting the output , but values are  not sorted even when i used sorting from low to high

how to do that, please help me

[manoranjan_d]

no reply

[nagaiank]

If you define your calculated dimension as the first dimension, dept as second dimension with sort order by expression sum(student) descending and sum(student) as expression, you will be able to get a stacked bar chart with the desired sorting.

[manoranjan_d]

can you pls send me the file or attach the file

[gautik92]

Have a look at this

[manoranjan_d]

i cant see ur file

[gautik92]

are yu using personal edition

[manoranjan_d]

if i use one dimesnion i m losing my  stac bar option in style, so i added calculated dimension as 1 and y-axis i did result is not coming

[manoranjan_d]

no, file s not attached when u said look at this

[gautik92]

i can see the file attached

any way