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]

now for using year i will give an example

year	student male	student female
2009	20
2009	10
2009	30
2009	40
2009	100
2009	200
2009	2000	20
2009		10
2009	2000	30
2009	2009	40
2009	3000	100
2009		200
2009	200	20
2009		10
2009	2000	30
2009		40
2009	30000	100

now i want stack bar so i used the first dimension as calculated dimension as 1 and second dimension as year and then in expression  first expression as count of (student male) and second expression i used count of student female

now i want to sort these this low to high of these two expression how to do this

[manoranjan_d]

hi naga and gowtham

pls help me on this

[gautik92]

may be like this

[manoranjan_d]

i want the bar in stack

[gautik92]

this one

[manoranjan_d]

ur file is not sorted  and its in stack bar only, but sorting is not happening