not working as expected

[soniasweety]

Hi All,

i have two  charts and two listboxes     here the issue  with alternate state

dimension1 and dimension2 

chart1 and chart2

so am using   state1 for  dimenson 1 and chart1

state2 for diemsion2 and chart2

issue:   when i select in chart2  chart 1 also   reflecting 

what might be the issue?

used xpression  for chart1: =sum({<[Type]= ,Dimension2= ,Measure2= >}[Amount])/$(vFormat)

used xpression  for chart2: =sum({<[Type]= ,Dimension1= ,Measure1= >}[Amount])/$(vFormat)

variable:  vFormat=FormatId

format id is field  and having values  1000,10000

thanks

Sony

[soniasweety]

any idea Ali Ahmad

[ogautier62]

Hi,

when you select in a chart it seems not to act as in a listbox,

so <field=> doesn't work,

add 1 before :

{1<type=, .....}

it will work

regards

[soniasweety]

so i have 5 measures in each measure i need to add?     for both the charts?

[ogautier62]

yes I think so

[soniasweety]

but still its reflecting   after adding 1 before

[ChennaiahNallani]

in chart purporting-> general tab

select chart1 = state1 and chart 2 = state2 like below

[tresesco]

Try mentioning state name in the expression as well, like:

sum( {State1<[Type]= ,...>}

[soniasweety]

yes i have set  for both  still not working

[soniasweety]

Still the same reflecting.

More info:

1 its an adhoc report

in first listbox and chart  i m selecting 1 dim and 1mesure  its showing values

in second  listbox and chart am selectng 1 dimension and 1measure    the first chart is showing  null dimension and some values.