RE:Dynamic sheet reflect

[Chanty4u]

Hi all,

i have a dynamic table.

Wih in that   i have Dimension as  "Project"  .so my req is

When i click on any of the projct   it will redirect to the specific sheet?

How can i achve this? 

Thanks in advance.

Suresh

[Chanty4u]

sunny...can u chk abe u hve attached ...its nt wit altrnate state?

canu upload update one

[#3]

Hi ,

May be like this you are asking for...

[sunny_talwar]

Although it did have the alternate state in the previous one as well, but reattaching it at the end of the post since I don't want you to get confused.

Will be updating to add screenshots so that you can follow along

Straight table is in alternate state

Trigger is not based on alternate state

[Chanty4u]

hi sunny,

wen u  clik on clear button and select in stright table   and come back to main sheet and select one value in listbox

again it reflecting to  other sheet.

Can u follow and chk abve as it is.

[sunny_talwar]

Its strange because I am staying on the Main tab when I make any selection in the list box. The only time I go to another tab is when I click on the straight table. Are you sure you looking at the right file . Let me attach it by renaming it a little

[Chanty4u]

no .if i selct one dimension in stright tble it will go to other sheet.  and in the  stright table sheet  i hve same dimension as listbox abd barchart ..... so if i select it is also gng to other sheet...now i dont want taht.

only it apply for stright table only  how can i?

[Chanty4u]

sunny i think my requirment is clear  ryt ...

1)_only stright table dimension vvalue selects it will go other sheet.

2) in  Main tab  if i select listbox value it will not go o other tab.

ok..  so u hve attached qvw...  wen i select listbox value it is gng to other tab

[sunny_talwar]

That is not happening for me. Is anyone else here on this thread want to give it a try? sathishkumar.gobi can you please check v1 version

[Chanty4u]

ur example only.....sunny.

how an i show to u?

[sunny_talwar]

when I click on the list box nothing happens except some filtration on the Main Tab