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]

[gautik92]

i hope it wont help you i misuds your req

[manoranjan_d]

hi naga,

i m getting the output thanks, when i m using the expression as ascending or descending  in sort tab, but in case if we are using two expression means how to do that ?

[manoranjan_d]

hi NagaianK

i m waiting for ur reply, how to do the same sort in the stack bar bar for two expression.

[gautik92]

This one

[manoranjan_d]

Hi gwtham,

can u send  me the file to my mail id maoranjan321988@yahoo.com, bcoz i cant see ur file

[gautik92]

what is the second expression

[gautik92]

i don have email access sry

ill tel the steps to do

first dimesion =valuelist('1')

second dimesion=dept

expr=sum(student)

sort=select dept->by expr->sum(sales) by desc

style stacked

[manoranjan_d]

i can see your file

[manoranjan_d]

gowtham u have to give sort expresiion only on dept, not on the both, just now checked it, then only assending or descending is happening, so remove the sort expression in the value list a