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

[sunny_talwar]

Have you tried the application I have added above?

[Chanty4u]

yes sunny....if it is in  stirht table how come it applicable?

Is ther e any other way?

[sunny_talwar]

Seems to be working with the straight table as well. Try out the attached

[Chanty4u]

yes sunny i hve tried dat one alry....but   if i select any other dimension or expression it is reflecng to other sheet..i dnt want that ....only prjct select it will redirect ?

Is this psble?

[sunny_talwar]

I don't think it should be doing that. Let me test it out.

[sunny_talwar]

Add another column and selection in that isn't taking me to another sheet. Check it out

[Chanty4u]

ok sunny ...let be a side of it.

And in that one more issue  is.... i hve that project in the same sheet    as listbox or  in bar chart group dimension..

so wen i selecting that listbox value it is also reflecting the other sheet . so i dnt want that?

how can i achve this?

[sunny_talwar]

Introduce alternate state. I have made the straight table in another alternate state. List box won't change sheet, but straight table will.

[Chanty4u]

chk attached

u can u.stnd my requrmnt.only that refct in stight table only...not in other chart or listbox

[sunny_talwar]

Check my response where I mentioned adding alternate state, I have provided a sample with it