RE:Alternate states

[Chanty4u]

Hi all

I have some issue.

I have two listboxes

Branch and Product.

I have created  one alt.state lik S1

I applied S1 to  Branch    and product is in Default state.

MyReq:  wen i select a value in branch    the product value shud be reflect.

how can i achieve this?

[swuehl · Accepted solution]

Try a field <expression> in your list box like

=Aggr(Only({s1}Product), Product)

[Chanty4u]

thnx swuehl

[sunny_talwar]

Another method would be to use an expression like this:

Sum({<Branch = s1::Branch>}[Top Line Target])

[Chanty4u]

No sunny.... not in bar chart   that shud be reflect for listbox

[sunny_talwar]

Oh okay... do you mean that something selected in the bar chart should show up in the list box?

[Chanty4u]

No. bro..      bar chart is exception...

only listbox  shud be reflect

[sunny_talwar]

I think I understand now. I had to check Stefan's app to see what you were trying to do