Issue on the Bar chart

[manoranjan_d]

Hi all,

below is my data

Data:

item Dept PORA Type 100 IT P Computer 200 CSE P Computer 300 IT P Computer 400 CSE A Computer 500 IT P Computer 600 CSE A Computer 700 IT A Computer 800 CSE P Computer 900 IT P Computer 1000 CSE A Computer 1100 IT P Computer 1200 CSE P Computer 1300 IT P Computer 1400 CSE P Computer 1500 IT A Computer 1600 CSE P Computer 1700 IT A Computer 1800 CSE A Computer

now my dash board  have list boxes and charts

list box has value of  computer , if user select the computer sub list box  of DEPT will appear which  has value of IT and CSE

scenario 1:

when the computer is selected from list box a stack bar chart has to appear which should  show the sum(item) for P and A. for this stack chart i used dimension as TYPE and PORA and the expression is sum(count). i got this stack bar successfully

scenario 2:

now i selected the computer and then sub list box of IT i selected , a another chart has to appear which should show the sum(item) P and A for computer and as well as for the dept IT with  two different stack bar where the values has to be displayed with inside segmet and the value has to be sorted from low to high.

i used two cal dim in the chart

=ValueList('Type','IT')

=ValueList('P','A')

and expression is

IF(ValueList('Type','IT') = 'Type' and ValueList('P','A') = 'P', SUM({<TYPE = {'P'}>}item),

IF(ValueList('Type','IT') = 'Type' and ValueList('P','A') = 'A',SUM({<TYPE = {'A'}>}item),

IF(ValueList('Type','IT')= 'IT' and ValueList('P','A') = 'P', SUM({<Dept= {'IT'}, FR_Type = {'P'}>}item),

IF(ValueList('Type','IT')= 'IT' and ValueList('P','A') = 'A', SUM({<Dept= {'IT'}, FR_Type = {'A'}>}item))))

in sort tab

selected the expression and placed the above expression to make the sort,

now under this scenario 2  i m facing issue with first stack bar doesn't show the correct value for Computer.

how to get the correct stack bar for the second senario

[manoranjan_d]

no reply