Attach two Tables

[#1]

Hi,

I am trying to detach or attach a table.

I have 2 tables and 1 list box and In that my requirement is if i click on the list box only one table should change the other remain constant.Is there any way i can do it by using expression.

[#2]

Please try alternate states. First create the alternate state and then go to your list table and assign the alternate state.

[#3]

In the table which you want to remain constant, two things can be done:

1.Either right click and select detach.. In this case the table will remain constant irrespective of any selection.

2.Or add an expression someting like:  Sum({$<[Listbox_field_name] =>}Sales)..... This will not refelect the change on the  selection of that particular field only.

[#4]

Hi Srasthi,

Thanks for the reply.

I am attaching a file to the initial post.Can u suggest me accordingly.

I want Month Table to remain constant irrespective of making selection in other boxes.

Thanks

Ankit

[ashfaq_haseeb]

Hi,

Maybe like this.

See the attached.

Regards

ASHFAQ

[#6]

Hi Asfaq,

Yes this is what I wanted however can you explain me how to do it?

Thanks

Ankit

[ashfaq_haseeb]

Hi

Go to document properties --> General tab --> Click on alternate state and create a new state.

No to to your month chart --> General tab and from alternate state drop down select the state you created above.

Regards

ASHFAQ

[#8]

Hi Ashfaq,

That really helped.

However is there any way that we can do it by Expression?

Thanks

Ankit

[ashfaq_haseeb]

Hi,

May be like this.

See the attached

Regards

ASHFAQ

[#10]

Hi Ashfaq,

What if I select anything from the month(List Box), it should reflect changes to the month(Table).

Can we do it?

Thanks

Ankit